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