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

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Wildwood" wrote in message
...
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,)))

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

Jim Thomlinson


"Wildwood" wrote:

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