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

Report
-
 Ragav -
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
Thank you

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

CCM 2781 users have said thank you to us this month

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