ExcelBanter - Replace #N/A with 0

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

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

- - Replace #N/A with 0 (https://www.excelbanter.com/excel-discussion-misc-queries/260238-replace-n-0-a.html)

Emece

Replace #N/A with 0

When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula?

Thanks in advance

Regards
Emece.-

Gary''s Student

Replace #N/A with 0

Something like:

=IF(ISNA(VLOOKUP(A1,B1:B2,2)),0,VLOOKUP(A1,B1:B2,2 ))

--
Gary''s Student - gsnu201001

"Emece" wrote:

When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula?

Thanks in advance

Regards
Emece.-

All times are GMT +1. The time now is 01:32 AM.