Excel Comparison
IFERROR vs IFNA: Which Should You Use for Lookups?
Use IFNA to replace a genuine #N/A from a lookup. IFERROR also hides #REF!, #NAME?, #VALUE! and #DIV/0!, which can conceal a broken formula.
#ifna
1 tutorial tagged “ifna”.
1 tutorial tagged “ifna”.
Use IFNA to replace a genuine #N/A from a lookup. IFERROR also hides #REF!, #NAME?, #VALUE! and #DIV/0!, which can conceal a broken formula.