Problem with drop down list and contents of second cell

T

theslaz

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..
 
E

Earl Kiosterud

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.
 
T

theslaz

Anne said:
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
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List 2
Drop-down list and error message 1
Filtered drop down list 2
Drop down menu 2
Excel Excel: How do I put a formula in a drop down list 11
Drop down list from index/match formula 1
drop down list 1

Top