ExcelBanter - Hiding #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/103604-hiding-n.html)

FP Novice

Hiding #N/A

How do I show cells as empty (that actually house VLOOKUP formulas) instead
of the default #N/A?

Todd

Marcelo

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

Dave Peterson

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

FP Novice

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

All times are GMT +1. The time now is 10:53 PM.