Vlookup question

[Craig]

Hi,

Instead of creating a huge nested if function I'm trying to use vlookup. I
would like vlookup to look at text in a cell, find its exact match from a
list, then return the text next to it in the list, in another cell.

Here is the formula I have created: =VLOOKUP(C3, C193:E198, E3)

For example, if C3 has the text "one" it returns "red" to E3.

One Red
Two Blue
Three Green
Four Yellow

Thanks,

Craig

 

[xlmate]

copy and paste this into E3

=VLOOKUP(C3,$C$193:$B$198,2,0)

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis

 

[Shane Devenshire]

Hi,

Technically if you mean by "exact match" case as well as spelling then the
vanilla VLOOKUP needs some modification:

=LOOKUP(TRUE,EXACT(E3,A1:A13),B1:B13)

Where the entry you want to lookup is in cell E3 and the lookup column is
A1:A13 and the data you want returned is in B1:B13.