ExcelBanter - View Single Post - choose a product from a drop down list i need it to insert a price

Barnzy

Thanks that worked great.

"Ron Coderre" wrote:

Hi, Barnzy

Let's create one more range name.....
On Sheet2
<insert<name<define
Names in worktook: LU_Price
Refers to: A1:B24

Now...on Sheet1
D12: =IF(COUNTIF(Units,A12),VLOOKUP(A12,LU_Price,2,0)," ")

Note: if the list of products and prices will continue to grow, you may want
to consider using Dynamic Range Names, which expand and contract to match the
volumn of data cells. Once again, Debra Dalgleish has the topic covered at
her website:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?

(Post back with more questions)
***********
Regards,
Ron

XL2002, WinXP

"Barnzy" wrote:

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.