Stop #N/A appearing after a vlookup

Solved/Closed
PM - Jul 22, 2009 at 07:12 AM
 Ragav - Feb 20, 2013 at 11:53 PM
Hello,

I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value.

Anyway I can make it appear as 0, or not at all??

thanks

PM

2 replies

One more simple formula to avoid "NA"

=iferror(vlookup....),"0")
55
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jul 22, 2009 at 08:42 PM
this may of help to you

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

take care of the number of brackets. sometimes excel itself will help you with suggestions.

example

=IF(ISNA(VLOOKUP(A13,A1:B4,2,FALSE)),"",VLOOKUP(A13,A1:B4,2,FALSE))
5