Question
What is the difference between using `IFNA()` and `IFERROR()` for VLOOKUP error handling in Google Sheets?
Asked by: USER4385
106 Viewed
106 Answers
Answer (106)
`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.