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)) |
#2
|
|||
|
|||
show blank instead of #N/A
=IF(ISNA(MATCH("CKT2",Schedule!$C$49:$C$102,0)),"" ,INDEX(Schedule!$B$49:$B$102,MATCH("CKT2",Schedule !$C$49:$C$102,0)))
-- Regards, Peo Sjoblom (No private emails please) "Sonya" wrote in message ... 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)) |
Reply |
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 |