💻 Software

Quick replace #N/A by 0 when vlookup

Fresh7 days ago

Mar 15, 2026278520 views

Confidence Score0%

Problem

I use a lot in excel. The problem is with value when the seek value is not found. In that case, we often replace it by 0 using which repeat vlookup(what,range,column,false) twice and make the formula look ugly & dummy to me. Do you have other work around for this issue?

Error Output

if(isna(vlookup(what,range,column,false));0; vlookup(what,range,column;false))

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Quick replace #N/A by 0 when vlookup

Low Risk

Which version of Excel? In Excel 2007 or later you can use IFERROR function like this

Awaiting Verification

Be the first to verify this fix

Quick replace #N/A by 0 when vlookup

Problem

Error Output

1 Fix

Fix for: Quick replace #N/A by 0 when vlookup

Environment