C1 C2 C3
A

R1 B C XXX



Hi, I am trying to modify a lookup formula to look up the value of
intersection of header A and Row with Header B and C to return value of (XXX)

Example formula below will return only the intersection of a column and a
row. Any suggestion on how to modify or new formula will be appreciated.
Thanks.

=INDEX('[PR-DATA-020306.xls]COM EAR'!$A$9:$J$1500,
MATCH($B96,'[PR-DATA-020306.xls]COM EAR'!$A$9:$A$1500,),
MATCH(C96,'[PR-DATA-020306.xls]COM EAR'!$A$9:$J$9,))