How To Remove #N/A in Google Sheets & Excel

Here's a quick and simple guide on how to remove #N/A errors in Google Sheets and Excel.

1. Open your formula
2. Add the IFNA function to the beginning of the formula
3. Add relevant parenthesis
4. Done!

Here is a quick example of a sample formula of an Index/Match without IFNA and with IFNA

• Without IFNA:

=INDEX(A1:A3,MATCH(B1,C1:C3,0))

• With IFNA:

=IFNA(INDEX(A1:A3,MATCH(B1,C1:C3,0)))

‍