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.

‍

• Open your formula

‍

• Add the IFNA function to the beginning of the formula

‍

• Add relevant parenthesis

‍

• 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)))

‍

‍

‍