| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(ISNA) Question - - -!
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,))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF(ISNA.. or ISERROR? question.. | Excel Discussion (Misc queries) | |||
| match formula question with isna | Excel Worksheet Functions | |||
| ISNA question | Excel Discussion (Misc queries) | |||
| So close and yet so far (IF ISNA question) | Excel Discussion (Misc queries) | |||
| ISNA question | Excel Worksheet Functions | |||
Threaded Mode
