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

Return 0 instead of #n/a 1
VLOOKUP - 0 instead of # N/A 8
VLOOKUP returning #N/A result 2
Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? 6
How to convert #N/A to 0 using Match? 8
#N/A error 4
vlookup challenge with hyphen data placement 2
VLookup 1

Top