FG
💻 Software

In Excel, can I provide a "default value" in case my formula returns #NA?

Fresh5 days ago
Mar 15, 202638844 views
Confidence Score0%
0%

Problem

For example, Say the value of a cell is: Here, I want the product of the two VLOOKUPs. But some rows may not be there, so it could return NA. If it returns NA, just put zero in this cell, but otherwise I want the product. It seems silly that you'd have to have that whole expression in there twice. …

Error Output

IF(ISNA(VLOOKUP(A3,somesheet!G:J,3,FALSE) * VLOOKUP(A3,someothersheet!A:D,4,FALSE)), 0, VLOOKUP(A3,somesheet!G:J,3,FALSE) * VLOOKUP(A3,someothersheet…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: In Excel, can I provide a "default value" in case my formula returns #NA?

Low Risk

If you have Excel 2007 or later versions you can use IFERROR function to avoid repetition or you can use a workaround like this in earlier versions

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment