Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List
Hi there
I am really struggling with a list. Basically, I have 3 colums, Product, Unit & Price. I want to create a drop down list which allows me to select multiple rows for a quote, but pulls in all 3 columns, therefore giving me the product name, the unit it is sold in and the cost per unit, without me having to type it in everytime. It absoloutely needs to have all 3 columns included, it is not an option to put everything into 1 column. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List
How about a multi column listbox?
See http://tinyurl.com/6hakfx http://www.excelguru.ca/node/34 --JP On Jun 4, 3:58*pm, Victoria_Wells wrote: Hi there I am really struggling with a list. Basically, I have 3 colums, Product, Unit & Price. I want to create a drop down list which allows me to select multiple rows for a quote, but pulls in all 3 columns, therefore giving me the product name, the unit it is sold in and the cost per unit, without me having to type it in everytime. It absoloutely needs to have all 3 columns included, it is not an option to put everything into 1 column. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List
You can do this with a data validation list in the first column, and
VLookup formulas in the adjacent columns. There are instructions and an example he http://www.contextures.com/xlOrderForm01.html Victoria_Wells wrote: Hi there I am really struggling with a list. Basically, I have 3 colums, Product, Unit & Price. I want to create a drop down list which allows me to select multiple rows for a quote, but pulls in all 3 columns, therefore giving me the product name, the unit it is sold in and the cost per unit, without me having to type it in everytime. It absoloutely needs to have all 3 columns included, it is not an option to put everything into 1 column. Is this possible? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |