Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup multiple data
Is it possible to have a cell contain two pieces of informaton (e.g., A1 =
"Me, You"), a vlookup statement to look for each pece of informaton in that cell (e.g., first "Me", then "You") in another sheet, and display the match in B1? Sheet 1 A1 = "Me, You" B1 = (after vlookup) "Art, Joe" Sheet 2 A1 = "Me" and B1 = "Art" A2 = "You" and B2 = "Joe" I tried all different kinds of =VLOOKUP with different functions, and I can't figure t out, of course I assume its possble to even use VLOOKUP in this way. Perhaps I need to use a macro? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup and multiple data | Excel Discussion (Misc queries) | |||
VLOOKUP From Multiple Data Sheets | Excel Worksheet Functions | |||
vlookup - return multiple data | Excel Discussion (Misc queries) | |||
Vlookup for multiple row data | Excel Worksheet Functions | |||
VLookup Multiple Data Rows | Excel Worksheet Functions |