Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Craig;218033 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 Try =VLOOKUP(C3, $C$193:$E$198, 2) Checkout the VLOOKUP syntax in XL's help -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59899 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup question | Excel Worksheet Functions | |||
vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP Question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Discussion (Misc queries) |