medium10 pts · first answer countsexcelformula-errorslookups

IFERROR hides too much

A lookup is wrapped as =IFERROR(XLOOKUP(...),"Not found"). Why might =IFNA(...) be a better choice?

A.IFNA runs much faster on very large lookup rangesB.IFNA catches only "not found", so real errors still showC.IFERROR does not work with XLOOKUPD.IFNA also repairs any #REF! errors automatically

Discussion 0

Join free to post in the discussion.

IFERROR hides too much

Discussion 0

Related questions