Problem with drop down list and contents of second cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

theslaz - 19 Jun 2005 17:15 GMT

Thanks in advance..I am trying to design a Invoice type document in
Excell. I have created a drop down list containg the names of various
products. When I select a product from this list I would like it also to
make reference to the price per unit of this product and I would like
this refernece to be in the adjacent right hand cell from where this
product is listed.
E.G. In column "A" I have listed all my different products. In column
"B" I have listed their respective prices. In column "C1"; I have
formatted the cell to contain a drop down list of all my products in
column "A". When I select a product from the drop down list it will be
displayed in "C1". I would like to also have it's corresponding price
displayed in Column "D1" .Is this possible!!

Thanks in advance..

Reply to this Message

Anne Troy - 19 Jun 2005 18:13 GMT

Yes, but you can hide your reference pricelist on another worksheet by using
named ranges for your data validation and vlookups. You need both:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft
_excel.htm
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Thanks in advance..I am trying to design a Invoice type document in
> Excell. I have created a drop down list containg the names of various
[quoted text clipped - 10 lines]
>
> Thanks in advance..

Reply to this Message

theslaz - 19 Jun 2005 22:26 GMT

> Yes, but you can hide your reference pricelist on another worksheet by using
> named ranges for your data validation and vlookups. You need both:
[quoted text clipped - 21 lines]
>>
>>Thanks in advance..

Thanks I have solved that problem with the lookup feature.

Trying to go one step futher with my list. What I have/want is to select
one of five categories in the orginal list. Then I would like to be able
to make a selection from the items listed under that category; in other
words; a list within a list.. It is these items that would have a price
associated with them.
E.g. Column "A" would have the names of the five categories. I would
choose one; then I would like to have the items under that category show
in a list in column "B". I would choose one and the price for that item
would show in column "C". I now know how to get the price to show;
thanks to your help. It is now the list that I'm having problems with.
Is this possible?

Thanks in advance

Jerry

Reply to this Message

Anne Troy - 19 Jun 2005 23:15 GMT

You bet, slaz.
You'll find that at Dick's Blog:
http://www.dicks-blog.com/archives/2004/05/11/conditional-data-validation/

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> > Yes, but you can hide your reference pricelist on another worksheet by using
> > named ranges for your data validation and vlookups. You need both:

http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft
_excel.htm

http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

> > *******************
> > ~Anne Troy
[quoted text clipped - 34 lines]
>
> Jerry

Reply to this Message

theslaz - 20 Jun 2005 01:03 GMT

> You bet, slaz.
> You'll find that at Dick's Blog:
[quoted text clipped - 54 lines]
>>
>>Jerry

Checked it out; tried it and it works. Thanks again!

Reply to this Message

Earl Kiosterud - 19 Jun 2005 18:15 GMT

Slaz,

The dropdown won't populate two cells. Let the drop down put in the product
name, then use VLOOKUP function in the second cell to retrieve the price
from your product table.

Signature

Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

> Thanks in advance..I am trying to design a Invoice type document in
> Excell. I have created a drop down list containg the names of various
[quoted text clipped - 10 lines]
>
> Thanks in advance..

Reply to this Message