VLOOKUP equivalent -- #NO MATCH error
Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should.
Any ideas? I'm at a loss.
Help Article Resources
Check out the Formula Handbook template!