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

 

[Pecoflyer]

Hi,

Instead of creating a huge nested if function I'm trying to us
vlookup. I
would like vlookup to look at text in a cell, find its exact match fro
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

Try =VLOOKUP(C3, $C$193:$E$198, 2)

Checkout the VLOOKUP syntax in XL's hel

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[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.