Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
combo box problem I am pulling my hair out about!!!!
I really hope someone can help me....
I am creating a quote form. It is for a roofing company and I want to be able to create a combo box which lets me select an item, and then in an adjacent column bring up the dollar value for that selected item. ie. MATERIAL AMOUNT COST TOTAL Colorbond 10m² $25 $250 Under 'Material' I want a list or combo box to select items from. When I select an item, I want the cost of it to show under the 'cost' column. How can I do this? Please help... Terry |
#2
|
|||
|
|||
Tinker around with this ..
First, set-up the Material - Unit Cost table below in Sheet2, in A2:C4 1 Colorbond 25 2 WP_Paint 20 3 Tile Type A 50 In Sheet1 ------------ Assume A1:D4 houses the headers: Material, Amt, Cost, Total Draw a combo box (from the Forms Toolbar) over cell A2 Right-click on it Format Control Put in: Input range: Sheet2!$B$2:$B$4 Cell link: $A$2 Click OK Put in C2 (under "Cost"): =VLOOKUP(A2,Sheet2!$A$2:$C$4,3,0) Test out the combo box .. Select "Colorbond", C2 will return: 25 Select "WP_Paint", C2 will return: 20 And so on .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "TerryStyles" wrote in message ... I really hope someone can help me.... I am creating a quote form. It is for a roofing company and I want to be able to create a combo box which lets me select an item, and then in an adjacent column bring up the dollar value for that selected item. ie. MATERIAL AMOUNT COST TOTAL Colorbond 10m² $25 $250 Under 'Material' I want a list or combo box to select items from. When I select an item, I want the cost of it to show under the 'cost' column. How can I do this? Please help... Terry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
Pulling hair out with VLOOKUP | Excel Worksheet Functions |