Return 0 instead of N/A

  • Thread starter Thread starter amc62
  • Start date Start date
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.
 
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
 
Another possibility:

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