=IF(ISNA) Question - - -!

[Wildwood]

Ok, I need help......

This formula returns constant errors......What am I missing?

=IF(ISNA(INDEX('Oct 09 Discrepancy'!$A$1:$C$875, MATCH("0166 Count",'Oct 09
Discrepancy'!$A$1:$A$875,), MATCH("Counts",'Oct 09
Discrepancy'!$A$1:$C$1,))),"", INDEX('Oct 09 Discrepancy'!$A$1:$C$875,
Match("0166 Count",'Oct 09 Discrepancy'!$A$1:$A$875,) Match("Counts",'Oct 09
Discrepancy'!$A$1:$C$1,)))

 

[Bernard Liengme]

Without seeing the data, hard to tell.
Try to debug
1) what is the result of MATCH("0166 Count",'Oct
09Discrepancy'!$A$1:$A$875,)
Why the last comma?
Try putting -1,0, 1 (as need) for the missing parm
2) Ditto the other MATCH
3) Does INDEX('Oct 09 Discrepancy'!$A$1:$C$875, 2,3) return the right value
(try other numbers)
best wishes

 

[Jim Thomlinson]

Please don't repost the same question again. You are better off to stick with
your original thread...