| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
show blank instead of #N/A
How would I ammend the statement below so that if there was no infomation to
return the resulting text would show blank instead of #N/A? =INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule !$C$49:$C$102,FALSE)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need the cell to show blank | Excel Worksheet Functions | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| zero values in charts-don't want to show as zero, but as blank | Excel Discussion (Misc queries) | |||
| Needs to Show blank please | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Threaded Mode
