Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
I am trying to figure out how to use a drop down list to make a quote sheet.
I have a list of items that have details such as price and size. What i want to happen is for me to pick the name of the item from a drop down list and have the other cells with the price and size to fill into their assigned cell. any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Use VLOOKUP formulas in the the price and size columns.
For more on that Function see Debra Dalgleish's site. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation lists with drop-down box for entering the customer names. http://www.contextures.on.ca/xlDataVal01.html Might be useful. Gord Dibben Excel MVP On Thu, 1 Dec 2005 09:29:02 -0800, "helgaas" wrote: I am trying to figure out how to use a drop down list to make a quote sheet. I have a list of items that have details such as price and size. What i want to happen is for me to pick the name of the item from a drop down list and have the other cells with the price and size to fill into their assigned cell. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |