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

PM - Jul 22, 2009 at 07:12 AM - 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
54
Thank you
One more simple formula to avoid "NA"

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

Thank you, Ragav 54

Something to say? Add comment

CCM has helped 1867 users this month

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Jul 22, 2009 at 08:42 PM
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))