Based on the selection of a dropdown list, automatically insert data into adjacent column

[kaldrazidrim]

Excel 2010

I know how to make a drop down list, and even know how to make a conditional drop down list that changes based on the contents of the first drop down. I need a drop down list in A1, that makes B1 automatically populate with some data pulled from another sheet.

Let's say on another sheet I have two columns of data:
Apples $1
Oranges $2
Bananas $3

I can make a drop down list for Apples, oranges and bananas. If I select Apples in the dropdown in A1, I want B1 to automatically populate with "$1".

The price of the fruit will change over time, so I need to be able to overwrite my dropdown list source data by pasting in revised lists of fruit and cost behind the scenes.

Any help greatly appreciated!

 

[Jerry Sullivan]

Is there any reason that you couldn't just have a simple lookup formula in B1 (Vlookup or Index-Match)?

Excel Workbook
	A	B	C	D	E
1	Bananas	$3		Apples	$1
2				Oranges	$2
3				Bananas	$3
Sheet

#VALUE!

</td></tr></table></td></tr></table>