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