I am trying to do a double lookup. Not sure why I cant get it working. I
tried both functions below:

=INDEX('[exp 05 09.xls]PivotSheet'!$D:$D,MATCH('[exp 05
09.xls]PivotSheet'!$A:$A=C1,MATCH('[exp 05 09.xls]PivotSheet'!$C:$C=A12,0)))
This was CSE-Entered
Returns #NUM!

=INDEX('[exp 05 09.xls]PivotSheet'!$D:$D,MATCH(C1,'[exp 05
09.xls]PivotSheet'!$A:$A,MATCH(A12,'[exp 05 09.xls]PivotSheet'!$C:$C,0)))
Returns 0


I know the values are in those sheets, but Im not getting the expected
results.

Please help.

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.