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.
Help Article Resources
Check out the Formula Handbook template!