View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default How not to show #N/A when using vlookup formula

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"inthestands" wrote in message
...
I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I
have
inputed. Many of the responses come back with #N/A. I would like to
remove
this. Using IF(V3="","", does not work, becasue there is data there.
What
do I need to add to my formula?
--
Thanks in advance,

inthestand