Match function for multiple criteria


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!