Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Price Lists
I built an estimate spreadsheet, I want to be able to choose a product
from a dropdown that I created and have a price automatically come up for that product in a different cell. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Price Lists
It sounds like you could build a table with the part numbers in column A and the
prices in column B. Then you could use data|validation for the dropdown and =vlookup() to retrieve the price. Debra Dalgleish has some notes for you: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html Musky wrote: I built an estimate spreadsheet, I want to be able to choose a product from a dropdown that I created and have a price automatically come up for that product in a different cell. Can anyone help? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Price Lists
http://cjoint.com/?fbrFQwbdjf
G H 1 Product Price 2 Computer 300 3 Keyboard 15 4 Screen 100 B2:Data/Validate/Liste =$G$2:$G$8 C2:=Vlookup(B2;G2:H8;2;false) http://cjoint.com/?fbrJUm38Gq http://www.excelabo.net/moteurs/comp...-listescascade http://www.excelabo.net/moteurs/comp...svalidationvba Cordialy JB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording a high price on a worksheet | Excel Worksheet Functions | |||
How do I update price lists easily from a central source? | Excel Discussion (Misc queries) | |||
annual increases in price lists | Excel Discussion (Misc queries) | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
Macro's for figuring Price Lists?!? | Excel Discussion (Misc queries) |