| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding #N/A
How do I show cells as empty (that actually house VLOOKUP formulas) instead
of the default #N/A? Todd |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding #N/A
Hi
=if(iserror(vlookup(........))," ",vlookup*(..........)) hth regards from Brazil Marcelo "FP Novice" escreveu: How do I show cells as empty (that actually house VLOOKUP formulas) instead of the default #N/A? Todd |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding #N/A
=if(iserror(vlookup(...)),"",vlookup(...))
if you're using xl2007, you may want to try: =iferror(vlookup(...),"") FP Novice wrote: How do I show cells as empty (that actually house VLOOKUP formulas) instead of the default #N/A? Todd -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding #N/A
Thank you both, it worked perfectly. Great Results Thanks!
"Dave Peterson" wrote: =if(iserror(vlookup(...)),"",vlookup(...)) if you're using xl2007, you may want to try: =iferror(vlookup(...),"") FP Novice wrote: How do I show cells as empty (that actually house VLOOKUP formulas) instead of the default #N/A? Todd -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
| workbooks keep hiding | Excel Discussion (Misc queries) | |||
| Hiding zero values | Excel Worksheet Functions | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| Hiding Column and Row Bars. | Excel Discussion (Misc queries) | |||
Linear Mode
