If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Vlookup
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 |
#2
|
|||
|
|||
Multiple Vlookup
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 On Aug 6, 2:02*pm, Iriemon wrote: 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 |
#3
|
|||
|
|||
Multiple Vlookup
=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" wrote in message ... 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 |
#4
|
|||
|
|||
Multiple Vlookup
THANKS ! Finally got it through my thick skull....
grin "Iriemon" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|