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.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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