What is the difference between using `IFNA()` and `IFERROR()` for VLOOKUP error handling in Google Sheets?

Responsive Ad Header

Question

Grade: Education Subject: Support
What is the difference between using `IFNA()` and `IFERROR()` for VLOOKUP error handling in Google Sheets?
Asked by:
106 Viewed 106 Answers

Answer (106)

Best Answer
(439)
`IFNA()` specifically handles only the #N/A error, returning a specified value when the VLOOKUP doesn't find a match. `IFERROR()` is more general and will catch any type of error that occurs within the VLOOKUP function (like #REF!, #VALUE!, etc.) and return the specified value. If you only want to handle cases where the lookup value isn't found, `IFNA()` is more precise. If you want to catch any potential error, `IFERROR()` is broader.