COUNTIF returning #NO MATCH
I have some sheet formulas that were working but once I made a few updates, not all return the #NO MATCH error. It's a simple COUNTIF formula that references a cell that populates from a VLOOKUP. When I recreated the formula on another blank sheet, it works fine but, as you can see below, the sheet formula will not work. Any help?
Help Article Resources
Check out the Formula Handbook template!