Arrow left
Back to 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 ­čĹç

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

No items found.