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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!