Populate column based on selection from a dropdown

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

That is exactly what I had in mind!
As newdoverman points out, I probably wasn't very clear in how I asked the question but you managed to decipher it and provide the solution. Well done!
Many thanks Glenn

Glenn's answer was spot on but thanks for taking the time to reply.