Match function for multiple criteria

Options

I need to match two criteria on two sheets to return a decision symbol.

screenshot from Sheet 1








Screenshot from Sheet 2










I need to match Warehouse Location & Locator ID and the Inventory Item number for a Yes Decision

No Match would yield a NO Decision.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!