#NO MATCH when counting the results of a VLOOKUP

Bianca_ ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to the nature of those particular rows. 

I am now getting a #NO MATCH error for all of my COUNTIFS formulas. 

I saw this post <https://community.smartsheet.com/discussion/errors&gt; and it seems like a similar problem, but the solution didn't work for me. I'm not sure if I'm implementing it wrong? 

Here is my formula:

=COUNTIFS([Project Year]:[Project Year], "2019", State:State, IFERROR(@cell, 0) = "AL")

Any help is appreciated! I've been staring at this all day!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!