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,))

C1 = A
A2 = B
B2 = C

Your data is on Sheet 2:
A in column A
B in column B
C in column C
data in column D

=INDEX(Sheet2!$D$1:$D$10, MATCH(1, ($A2=Sheet2!$B$1:$B$10) *
($B2=Sheet2!$C$1:$C$10) * (C$1=Sheet2!$A$1:$A$10), 0))


--
Rob van Gelder - http://www.vangelder.co.nz/


"SID" wrote in message
...

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,))