Vlookup for the cell contain the text

smahesh2210

New Member
Joined
Oct 29, 2012
Messages
9
Hi

I wanted to go the Vlookup for the cell contain the Text.

Request you to advise what is the formula for the same.

Thanks in advance...

Thanks
Mahesh
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
if A1 = red and you make a table blue.....1
...........................................................red......2
..........................................................white.....3

in B1 =vlookup(A1,mytable,2) and it will return 2
 

smahesh2210

New Member
Joined
Oct 29, 2012
Messages
9
Thanks for your reply,

Sorry I have not able understand the answar.

let me brief the question as below

Exce file 1</SPAN>Values</SPAN> Exce file 2</SPAN>Values</SPAN>
ABC</SPAN>vlookup to pull the values</SPAN> EFG</SPAN>25</SPAN>
EFG</SPAN> XYZ</SPAN>31</SPAN>
XYZ</SPAN> ABC</SPAN>25</SPAN>

With vlookup I need to bring the values in the excel file 1

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3></COLGROUP>
 

Useful

Active Member
Joined
Mar 16, 2011
Messages
494
Hello!

=Vlookup(search_criteria_from_excel_file_1,range_from_excel_file_2,2,0)
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
My answer took for example efg and returned 25 i thought that was what you wanted
 

Watch MrExcel Video

Forum statistics

Threads
1,112,993
Messages
5,543,177
Members
410,583
Latest member
jgalin
Top