Excel 2007 : vlook up with multiple criteria

**gill389** · 07-06-2011, 11:34 AM

i have 300,000 lines of data, and dont want to do a filter, so i was wondering if anyone can help with a vlook up.

THe problem is the name i am looking up shows up multiple times, but with I do the vlookup it only brings back the first instance.
Any help:

Please Login or Register  to view this content.

im not sure if i should include the Index and columns, but not sure if it will work. Any feedback,
I included a small sample.:

**Paul** · 07-06-2011, 11:42 AM

Hi Gill,

VLOOKUP is only supposed to return the first match (or approximate match). What are you trying to get it to do? Return the last match? Return all matches? It doesn't work that way. You would have to use different formulas to get multiple matches in separate cells, or a macro if you wanted all the results in one cell. (Or one very long formula.)

**gill389** · 07-06-2011, 02:15 PM

im trying to return the first match, and then as there are multiple "MAQUINA" in the data. Thus after the vlook up finds the first Maquina, and brings back the #, i want to be able to go down and look up the next one Maquina and bring back the third offset cell. I was wondering if it can be done with the vlook up.