Thread
:
Hiding #N/A
View Single Post
#
2
Posted to microsoft.public.excel.misc
Marcelo
external usenet poster
Posts: 1,047
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
Reply With Quote
Marcelo
View Public Profile
Find all posts by Marcelo