Correction, x y axis question...

[Guest]

I have a matrix with x axis and y axis

X axis has column headers of A, B, C
Y axis has row headers of D,E,F

If I enter "B" in cell a1, and "G" in cell a2 , i want the intersect
value "8" to appear in cell a3

A B C
E 1 2 3
F 4 5 6
G 7 8 9

Thanks

 

[Guest]

Assuming your matrix is in cells F2:I4 (F2 is blank)

=INDEX(G2:I4,MATCH(A2,F2:F4),MATCH(A1,G1:I1))

 

[Guest]

thank

Assuming your matrix is in cells F2:I4 (F2 is blank)

=INDEX(G2:I4,MATCH(A2,F2:F4),MATCH(A1,G1:I1))