Why am I getting No Match error?!


I am using this formula above - the price with tax and product name are on a second sheet.

Ideally, what I would like for it to do is when the product is chosen from a drop down list, it searches the other sheet for that product and return with the price with tax to populate the cell.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!