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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,109,453
Messages
5,528,875
Members
409,843
Latest member
akostaki
Top