Multiple Vlookup

[Iriemon]

I found another post with the following solution to my problem,
unfortunately, I am not understanding how this works.

=INDEX(C1:C100, MATCH(D1&D2,A1:A100&B1:B100,0))
which is also an array formula, so commit with Ctrl-Shift-Enter.


I have the following data (simplified)

Col A Col B Col C

Row 1 12 1.75 C
Row 2 12 1.50 F
Row 3 12 1.25 EF


My data is

Row 10 12 1.50 Formula here (should return "F")
Row 11 12 1.75 Formula here (should return "C")

Please explain how to build my formula

THANKS

J

 

[Pete_UK]

I think you'll find that D1 and D2 in the formula are equivalent to
your A10 and B10, so change these references. Also, you only have 3
rows of data, so the formula in D10 becomes:

=INDEX(C1:C3, MATCH(A10&B10,A1:A3&B1:B3,0))

Commit with Ctrl-Shift-Enter, then copy into D11.

Hope this helps.

Pete

 

[Bob Phillips]

=INDEX($C$1:$C$3, MATCH(1,($A$1:$A$3=$A10)*($B$1:$B$3=$B10),0))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Iriemon]

THANKS ! Finally got it through my thick skull....

<grin>