

 Thread Tools  Search this Thread 
#1
 
 
How to use VLOOKUP IF in cell that contains Text
Can anyone advise me how I do a VLOOKUP if a cell Contains a certain word. The cells contain various sizes which are either Standard, Secure or Secure Plus. Thanks 
#2
 
 
Re: How to use VLOOKUP IF in cell that contains Text
One way to do that is, with data in A1 =IF(ISERROR(SEARCH("Secure Plus",A1)),"",your_lookup_formula) Or another method = IF(ISERR(SEARCH("Secure Plus",A1)),"",VLOOKUP(A1,E1:F12,2)). 
#3
 
 
Re: How to use VLOOKUP IF in cell that contains Text
What I can assume that you are trying to find a numeric value in a column that might be text values, the solution is to convert the text value to search for the formula TEXT (value, format) or seek to convert the column where the value in numbers to do so, in a parallel column, enter = VALUE and drag the formula down until the last record, once done, copy and the first cell of the matrix Give original edit > paste special > values, it should work. Like for example :


Tags: microsoft excel, microsoft office, office application, spreadsheet, vlookup 
Thread Tools  Search this Thread 

Similar Threads for: "How to use VLOOKUP IF in cell that contains Text"  
Thread  Thread Starter  Forum  Replies  Last Post 
How to get multiple values of Vlookup in Single Cell  Henriksen  MS Office Support  4  25022012 10:02 AM 
Using VLookup to give Hyperlink to a cell in another worksheet  AlpAnA$  Software Development  4  13072011 09:34 PM 
Number stored as text in vlookup  Alexander102  Windows Software  3  09062009 09:00 AM 
How to change cell formula to text in VBA  Chhaya  Software Development  3  08052009 12:12 PM 
Autopopulate a MS Word table cell with text from a diff cell?  dreamrthts  Windows Software  5  23032009 10:39 PM 