Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
Hi,
I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
Hi David,
See Debra Dalgleish's VLooup tutorial at: Excel -- Worksheet Functions -- VLookup http://www.contextures.com/xlFunctions02.html --- Regards, Norman " wrote in message ... Hi, I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
I don't see vlookup having a role in the scenario you describe
assumptions B1: car cat dog farm G1: car H1: =IF(ISERROR(SEARCH(G1,B1,1)),"",G1) But I may be misinterpreting the question. -- Regards, Tom Ogilvy " wrote: Hi, I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
Hi Tom,
Thanks for the help. That said, what if both B1 and G1 were in a range. ex: Column A Column B Column C car cat dog farm spaceship car ship boat rock sand car apple orange banana wallet Here Car shows up in row one Column C because row 1 of column A has car within the data set. thanks, David Kim "Tom Ogilvy" wrote: I don't see vlookup having a role in the scenario you describe assumptions B1: car cat dog farm G1: car H1: =IF(ISERROR(SEARCH(G1,B1,1)),"",G1) But I may be misinterpreting the question. -- Regards, Tom Ogilvy " wrote: Hi, I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
your checking what against what?
Are you breaking apart all the entries in A1 and seeing if they match anything in B1:B3? what if there is more than one match. or are you checking all the entries in column B against all the entires in column A and only one was found, so that was place in the first row in C. What if there is more than one match? -- Regards, Tom Ogilvy " wrote: Hi Tom, Thanks for the help. That said, what if both B1 and G1 were in a range. ex: Column A Column B Column C car cat dog farm spaceship car ship boat rock sand car apple orange banana wallet Here Car shows up in row one Column C because row 1 of column A has car within the data set. thanks, David Kim "Tom Ogilvy" wrote: I don't see vlookup having a role in the scenario you describe assumptions B1: car cat dog farm G1: car H1: =IF(ISERROR(SEARCH(G1,B1,1)),"",G1) But I may be misinterpreting the question. -- Regards, Tom Ogilvy " wrote: Hi, I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUPS
On Apr 26, 1:32 pm,
wrote: Hi Tom, Thanks for the help. That said, what if both B1 and G1 were in a range. ex: Column A Column B Column C car cat dog farm spaceship car ship boat rock sand car apple orange banana wallet Here Car shows up in row one Column C because row 1 of column A has car within the data set. thanks, David Kim "Tom Ogilvy" wrote: I don't see vlookup having a role in the scenario you describe assumptions B1: car cat dog farm G1: car H1: =IF(ISERROR(SEARCH(G1,B1,1)),"",G1) But I may be misinterpreting the question. -- Regards, Tom Ogilvy " wrote: Hi, I'm looking to create a vlookup that will extract data from within a cell that matches with something found in a range. input cell range results cell car cat dog farm car car- Hide quoted text - - Show quoted text - Are all values in column A unique or, can they be found more than once? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I sum several vlookups ?? | Excel Worksheet Functions | |||
Vlookups (sum of) | Excel Worksheet Functions | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Vlookups | Excel Discussion (Misc queries) | |||
Vlookups | Excel Programming |