Products and Prices

Hi, new here and couldn't find a thread that covers this, prob is but not found.

I want to select a product from a drop down list (already created), this then inserts a price in a cell a few columns along.

The worksheet is a record of quotes sent out, so the item selected from the list could be the same or different from previous ones.

There is a separate worksheet, in the same workbook, containing the prices for each item.

When a product is selected the location of the price would be in the same cell every time for that product.

I'm sure there is a simple solution but I can't figure it out.

Thanks

Chris

Chemist

I've attached (I think)a cut down version of the worksheet.

Sheet 1 is the sheet which I will be working from.

The drop down menu is in column C, so having selected a product from the list, I then want the price/kg to be inserted into the same
row but column D.

Sheet 2 contains the price data.

The problem I can't solve is getting Excel to look for the correct product and then to get that product price.

Does that make sense?

Chris

Hi Chem

Sorry for the delay in getting back to you and thank you for the response.

I get #N/A in the cell I pasted the formula into.

There was a bracket missing at the end which I added.

I can see what you did but it does not seem to be able to pick up the price from col B in sheet 2.

Any thoughts?

Nicely put!

You are quite right and I was not thinking.

Your suggestion works perfectly now.

Many thanks.