Hi,

I have reviewed a few answers to similar questions on the site but I'm afraid I haven't found anything that quite works! Hence I have registered!
I describe my problem below and have simplified it a little, I hope its clear enough...


Worksheet 1
Column A is a list of 10 items
Elsewhere on the sheet is a cell with a dropdown containing 3 options; low, average, high

Worksheet 2
I have (on another worksheet) the same list of 10 items with a low price estimate, average price estimate and high price estimate next to them.

I would like to select, say, "high" from the dropdown on Worksheet 1 and have Column B populated with the corresponding data from the high price estimate pulled from Worksheet 2. If I then changed the dropdown to "Average" the prices would switch to the average prices etc.

I will be hugely grateful for any help anyone can give me, many thanks!
D