Thread: Hiding #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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