Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with Multiple Rows to match with one row
I am trying to match a one record to a list with multiple like records and
only retrieve from the first record: Record 1 Jim Smith look up to Record 2 Record 2 Jim Smith Nice Guy Record 2 Jim Smith Not so Nice Guy In otherwords when I do my vlookup VLOOKUP(B12,'Overall Transformations '!A:Y,17,0) it sees the two records in record 2 and brings back N/A#. How do I tell it to bring back the first instance that it sees with Jim Smith Nice Guy? -- Motaad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with Multiple Rows to match with one row
Me thinks something else is causing the #N/A.
If you have two Jim Smith's in the lookup array, it should return the first one only and not "see" the second one. (I assume the N/A# in your post is a typo) Might not really have a match...? Spaces or something like that. HTH Regards, Howard "Motaad" wrote in message ... I am trying to match a one record to a list with multiple like records and only retrieve from the first record: Record 1 Jim Smith look up to Record 2 Record 2 Jim Smith Nice Guy Record 2 Jim Smith Not so Nice Guy In otherwords when I do my vlookup VLOOKUP(B12,'Overall Transformations '!A:Y,17,0) it sees the two records in record 2 and brings back N/A#. How do I tell it to bring back the first instance that it sees with Jim Smith Nice Guy? -- Motaad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with multiple fields that need to match | Excel Worksheet Functions | |||
Vlookup with Multiple Columns to Match | Excel Discussion (Misc queries) | |||
multiple vlookup; index/match | Excel Discussion (Misc queries) | |||
Multiple If/Vlookup/Match | Excel Worksheet Functions | |||
Please Help! vlookup & match with multiple variables | Excel Worksheet Functions |