| 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 |
| 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 | |||
Threaded Mode
