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

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??


See more 

2 replies

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


Thank you, Ragav 54

Something to say? Add comment

CCM has helped 1592 users this month

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