Vlookup for the cell contain the text

[smahesh2210]

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

 

[oldbrewer]

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]

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]

Hello!

=Vlookup(search_criteria_from_excel_file_1,range_from_excel_file_2,2,0)

 

[oldbrewer]

My answer took for example efg and returned 25 i thought that was what you wanted