| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hide #N/A
Is there a way to hide the #N/A result when using the VLOOKUP command in
Office 2003? I want to hide #N/A until I type in a value that gives me an actual result . THanks |
|
#2
|
|||
|
|||
|
Hide #N/A
PLEASE DISREGARD THIS POST...I received the answers I needed thanks!
"Scott" wrote: Is there a way to hide the #N/A result when using the VLOOKUP command in Office 2003? I want to hide #N/A until I type in a value that gives me an actual result . THanks |
|
#3
|
|||
|
|||
|
Hide #N/A
=IF (ISNA(your vlookup), desired response if NA, your vlookup)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide toolbars, menu bar, etc | Excel Discussion (Misc queries) | |||
| hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
| How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
| Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions | |||
| Conditional Hide function for Excel | Excel Worksheet Functions | |||
Linear Mode
