ExcelBanter - Return 0 instead of N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Return 0 instead of N/A (https://www.excelbanter.com/excel-discussion-misc-queries/245887-return-0-instead-n.html)

amc62

Return 0 instead of N/A

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.

Jacob Skaria

Return 0 instead of N/A

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
---------------
Jacob Skaria

"amc62" wrote:

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.

T. Valko

Return 0 instead of N/A

Another possibility:

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

--
Biff
Microsoft Excel MVP

"amc62" wrote in message
...
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.

All times are GMT +1. The time now is 08:59 PM.