That works! Thanks so much!
Ryan---

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


"Luke M" wrote:

My apologies. On re-reading your post, I see that your first formula is
CSE-entered, thus explaining the "=" operator.

If column D is a number:
=SUMPRODUCT(('[exp 05 09.xls]PivotSheet'!D2:D2000),--('[exp 05
09.xls]PivotSheet'!A2:A2000=C1),--('[exp 05 09.xls]PivotSheet'!C2:C2000=A12))

If column D is text:
=INDEX('[exp 05 09.xls]PivotSheet'!D:D,SUMPRODUCT(MAX(ROW('[exp 05
09.xls]PivotSheet'!D2:D2000)*('[exp 05 09.xls]PivotSheet'!A2:A2000=C1)*('[exp
05 09.xls]PivotSheet'!C2:C2000=A12))))

Note that the arguements within SUMPRODUCT can't callout entire columns,
unless using XL 2007.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

You are not using either INDEX of MATCH correctly! I'm not exactly sure what
type of result you are expecting, but you can not use a single column in
Index and then use 2 other variables.

Also, why do your MATCH functions contain "=" operators? The structure for
MATCH is:
=MATCH(LookupValue,LookupArray,MatchType)

If you could provide more detail about what it is exactly you're trying to
do, we might be able to provide additional help.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ryguy7272" wrote:

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''.