lookup matrix

[Jack]

I have the following matrix. I'm given the values of C and bb
How would i write a macro to get the result? which is 8.

aa bb cc
A 1 2 3
B 4 5 6
C 7 8 9
D 10 11 12
E 13 14 15

thanks
Jack

 

[smartin]

I have the following matrix. I'm given the values of C and bb
How would i write a macro to get the result? which is 8.

aa bb cc
A 1 2 3
B 4 5 6
C 7 8 9
D 10 11 12
E 13 14 15

thanks
Jack

With your data in A1:B6 here is a worksheet function that will do it.

=INDEX(B26,MATCH("C",A2:A6,0),MATCH("bb",B11,0))