VLOOKUP from drop down menu

Hi

I am trying to form a spreadsheet whereby there is a Product drop down menu which I have done. However I want the price cell to automatically populate whenever I select the product (all differently priced).

What's the best way to do this please?

Depending on how your data is laid out, you would normally use a VLOOKUP function or an INDEX/MATCH combination. Attach a sample workbook so we can give more detailed advice.

Hope this helps.

Pete

QC Localised TEST2.xlsm

ORANGE cells please. (on 2 tabs)

Where are the drop-downs that you say you have done?

Pete

In the orange shaded area to the left - click on any of those cells and a drop down list will appear. This list is linked via data validation to the data tab then.

excellent that works thanks bebo