Hiding #N/A

[FP Novice]

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

Todd

 

[Marcelo]

Hi

=if(iserror(vlookup(........))," ",vlookup*(..........))

hth
regards from Brazil
Marcelo

"FP Novice" escreveu:

 

[Dave Peterson]

=if(iserror(vlookup(...)),"",vlookup(...))

if you're using xl2007, you may want to try:
=iferror(vlookup(...),"")

 

[FP Novice]

Thank you both, it worked perfectly. Great Results Thanks!