Last Updated on April 13, 2023 by Jake Sheridan
In this tutorial, you will learn how to use the IFNA function in Google Sheets
How to Use IFNA Function in Google Sheets
The IFNA function in Google Sheets is a useful tool for handling cases where your formula returns a #N/A error.
The function allows you to specify a return value if that particular error is returned by the function indicated in the argument.
The #N/A function often occurs when a VLOOKUP function fails to find a match for a given search key.
We can wrap our VLOOKUP functions with an IFNA function to catch any errors and return a default value instead.
Do note however that IFNA function specifically targets #N/A error. If you want to catch all possible errors, you way want to use the IFERROR function instead.
In this guide, we will show you how to use the IFNA function in Google Sheets + How to Handle the #N/A Error in Google Sheets
How to Handle the #N/A Error in Google Sheets
Here’s how to handle the #N/A error in Google Sheets.
Our VLOOKUP formulas in column F enable us to retrieve the unit price of items specified in column D. However, if the item does not appear in the lookup table, the formula will return a #N/A error.
Wrap the VLOOKUP function with an IFNA function and select the value to return if the error is detected.
In the example above, we will return a value of 0.
We can also choose to return a string instead.
Do note that the second parameter for the IFNA function is optional. If no return value is specified, the function simply returns an empty string when it catches a #N/A error.
This guide should be everything you need to start using the IFNA function in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.