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









"Craig" wrote:

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