Why am I getting No Match error?!

Misty C.

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.

Paul Newcome

That is saying the data in the [Supply Type] column is not found anywhere within the {Product Name} range.

Paul Newcome

That is saying the data in the [Supply Type] column is not found anywhere within the {Product Name} range.