Stop #N/A appearing after a vlookup [Solved/Closed]

- - Latest reply:  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
See more 

2 replies

Best answer
55
Thank you
One more simple formula to avoid "NA"

=iferror(vlookup....),"0")

Say "Thank you" 55

A few words of thanks would be greatly appreciated. Add comment

CCM 6296 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
784
5
Thank you
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))