Stop #N/A appearing after a vlookup

PM - Jul 22, 2009 at 07:12 AM
 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??



2 responses

One more simple formula to avoid "NA"

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.