Arrow left
Back to product guides
Google Sheets Formulas

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

ÔÇŹ

Learn how to do this step-by-step in the video below ­čĹç

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711