wdprice3
BinaryBuffonary
45912 Posts
user info
edit post |
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
[Edited on December 10, 2015 at 11:11 AM. Reason : /]
[Edited on December 10, 2015 at 11:14 AM. Reason : .] 12/10/2015 11:11:02 AM
|
