Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use two drop-down list to fill data
I need to creat a estimate form. A1 cell with dropdown list for model and B1
cell with dropdown list for different size. How I can get the price at C1 when I select one of the model then select one of the size? such as: Model: M1, M2, M3, M4 Size: 10', 15', 20' Price:M1 with 10' is $100, M1 with 15' is $120, M1 with 20' is $140 M2 with 10' is $110, M2 with 15' is $130 ...etc. When I selected M1 for model at A1 and selected 15' for size at B1, C1 should shows price $120. When I selected M2 for model at A1 and selected 10' for size at B1, C1 should shows price $110. If I can get help for this problem, I would really appreciate. Thanks! Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a drop down list to auto fill other cells... | Excel Discussion (Misc queries) | |||
Fill in rows with Information from Drop Down list | Excel Worksheet Functions | |||
Fill Drop Down with List | Excel Discussion (Misc queries) | |||
Drop Down List & Auto Fill | New Users to Excel | |||
Auto Fill from Drop Down list | Excel Worksheet Functions |