Multiple conditions for vlookup

As you can see, I have to do a vlookup for the yellow highlighted cells using the three worksheets. I thought you to do index/match.

Formula:

Please Login or Register  to view this content.

This can do it:

J2:

=LOOKUP(2,1/(Sheet3!$A$2:$A$217=LOOKUP(2,1/(Sheet2!$A$2:$A$1291&Sheet2!$B$2:$B$1291&Sheet2!$C$2:$C$1291=Sheet1!A2),Sheet2!$D$2:$D$1291)),Sheet3!$H$2:$H$217)

and copy down

There are some array options that could do it as well, such aS concatenated ranges in conjunction with VLOOKUP or even a nested SUMPRODUCT.

What bout doing this too?

I thought that at first, but the very first value listed is 13 and on tab 3 there are no Fiat models with a Residual of 13.

You haven't explicitly stated what you're looking for, just that the yellow needs filled in.

If the values on tab 3 are irrelevant, then are you just pulling back the ID's on tab 2 that match Yr/Make/Model on tab 1?

I wish more instructions