Return 0 instead of N/A

A

amc62

I am using the formula: =VLOOKUP(P8,'ftg pivot table'!A2:B2847,2,FALSE)
I need this to return 0 rather than n/a when no exact match is found.
 
J

Jacob Skaria

Try the below which handle the error using ISNA()

=IF(ISNA(VLOOKUP(P8,'ftg pivot table'!A2:B2847,2,0)),0,
VLOOKUP(P8,'ftg pivot table'!A2:B2847,2,0))

If this post helps click Yes
 
T

T. Valko

Another possibility:

=IF(COUNTIF('ftg pivot table'!A2:A2847,P8),VLOOKUP(P8,'ftg pivot
table'!A2:B2847,2,0),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VLOOKUP returning #N/A result 2
Vlookup to return 0 instead of NA 1
Same forumula returns both 0 & N/A 2
Return 0 instead of #n/a 1
VLOOKUP - 0 instead of # N/A 9
VLOOKUP returning #N/A ?? 3
How to convert #N/A to 0 using Match? 8

Top