Data Table in A1:H8

Column headers in B1:H1
Row Headers in A2:A8

Column value to lookup in A12
Row value to lookup in A13

=INDEX($A$1:$H$8,MATCH(A12,A1:A8,0),MATCH(A13,A1:H 1,0))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Val from ICB" <Val from wrote in message
...
How can I have the formula look at a 2 different cells for values, match
them
to a row and column on a chart and input the value at the intersection.
The
XINDEX function works this way in Lotus 123.