81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Checks whether a value is the error `#N/A`.

How To Use in Sheets


External Links

How to Compare 2 Lists in Spreadsheets:

Let's discover the formula for comparing 2 lists in spreadsheets and apply it to a framework. We'll discuss the ISNA and MATCH functions, along with the IF, AND, and OR. The framework involves determining which members of your club participate in all 3 volunteer activities and therefore receive gold stars. The related post can be found on www.spreadsheetsolving.com/posts

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.