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