| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding #N/A error (or displaying a blank cell instead of #N/A)
Hello,
I have a formula which is working correctly; however when it doesn't locate the data (as will happens sometimes), it displays the #N/A error. I would prefer it display a blank cell. Can someone please tell me how to do this in Excel? Formula: =IF(P28=0,"",INDEX('Ext''d Lines'!$B$1:$CD$1,MATCH(P28,INDEX('Ext''d Lines'!$B$2:$CD$230,MATCH($A28,'Ext''d Lines'!$A$2:$A$230,0),0),1)+1)) Thanks, Eva Marie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUtomatically hiding a row when a certain cell is blank | Excel Discussion (Misc queries) | |||
| Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
| cell text not displaying into next blank cell | Excel Discussion (Misc queries) | |||
| Hiding Rows if Blank cell | Excel Worksheet Functions | |||
| Displaying a blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
