Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Double Lookup
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''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Lookup | Excel Worksheet Functions | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
Double LOOKUP? Help please... | Excel Worksheet Functions | |||
double lookup | Excel Worksheet Functions | |||
Double lookup | Excel Worksheet Functions |