I need to lookup values in a table by matching three criteria. The first column has duplicate row entries, the second column has unique entries per for each of COL A's values, the third column is what I need to return.

So I need to return Col C for each permutation from Col A and Col B (A,X; A,Y; AZ;..;C,X;C,Y;C,Z). I'm familiar with using INDEX, and I imagine this needs an OFFSET, but I'm less familiar with using that function. Or maybe a nested INDEX will work

Col A  Col B  Col C
A       X        1
A       Y        5
A       Z        10
B       X        3
B       Y        4
B       Z        7
C       X        4
C       Y        9
C       Z        11

12/10/2015 11:11:02 AM

Why not just concatenate Col A and B and do a VLOOKUP?

12/10/2015 11:39:48 AM

I can do that, but It's a bit of a pain since I'm dealing with lots of separate data sets/spreadsheets.

12/10/2015 11:48:09 AM