software

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 A in cell a1 (B), and E in cell a2 (G), 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 8

ThanksAssuming Column headers are in B77,
Row headers in A8:10,
Data in B810,
the formula is:
=INDEX(B810;MATCH(A2,A8:A10);MATCH(A3,B77))HTH
--
AP

quot;JcRquot; gt; a écrit dans le message de
news
gt; I have a matrix with x axis and y axis
gt;
gt; X axis has column headers of A, B, C
gt; Y axis has row headers of D,E,F
gt;
gt; If I enter A in cell a1 (B), and E in cell a2 (G), i want the intersect
gt; value (8) to appear in cell a3
gt;
gt; A B C
gt; E 1 2 3
gt; F 4 5 6
gt; G 7 8 8
gt;
gt; Thanks
gt;
thanksquot;Ardus Petusquot; wrote:

gt; Assuming Column headers are in B77,
gt; Row headers in A8:10,
gt; Data in B810,
gt; the formula is:
gt; =INDEX(B810;MATCH(A2,A8:A10);MATCH(A3,B77))
gt;
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;JcRquot; gt; a écrit dans le message de
gt; news
gt; gt; I have a matrix with x axis and y axis
gt; gt;
gt; gt; X axis has column headers of A, B, C
gt; gt; Y axis has row headers of D,E,F
gt; gt;
gt; gt; If I enter A in cell a1 (B), and E in cell a2 (G), i want the intersect
gt; gt; value (8) to appear in cell a3
gt; gt;
gt; gt; A B C
gt; gt; E 1 2 3
gt; gt; F 4 5 6
gt; gt; G 7 8 8
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;