That all looks great but i have no idea how to use the code. I have figured
out how to create a drop down list that refers to sheet 2 but can not figure
the rest out. Please bear with me as i have only just started using excel.
I will try to explain it.
On sheet2 I have 2 columns. In column A Rows 1-24 is a list of products
(that i have named "units") for a data validation list. In column B Rows 1-24
is the corresponding price of the units. such as B1 is the price of A1 and so
on.

Now on Sheet1 A12 is a drop down list (=units) Now i need Sheet1 D12 to show
a related price to the product chosen in A12.

Can someone hold my hand through this and help me wrap my head around this
so I can understand it.

Thanks

"Barnzy" wrote:

i need to know how to have a related price show up in column D when i choose
a product from a drop down list in column B

ex. B C D
TTW036 $6495.50


I have about 30 differant products each with their own price.