Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combo box
Hi,
I intend to create three scenarios with each scenario incorporating two sets of variables (asset price and daily rate for example), and then use Combo Box to select a scenario. How can I do this? Thanks! tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combo box
would be happy with an answer on the below problem a friend has asked me to
post, I believe there is an alternative, but also encounter a problem given: in cell A1 a list is created (data validation), referring to cells A3, A4, A5 A B C D 3 worst 12 12 13 4 base 12 15 18 5 best 12 16 21 In row 6 I want the data depending on the chosen scenario My solution: B6=VLOOKUP(A1,A3:D5,2) etc... however, the row is quite long, so that means that for every column I have to rewrite the formula... is there an alternative for this? QUESTION 2: why should one use a combo box in thes case? what is the advantage as compared to creating a list as described above? "tom ossieur" wrote: Hi, I intend to create three scenarios with each scenario incorporating two sets of variables (asset price and daily rate for example), and then use Combo Box to select a scenario. How can I do this? Thanks! tom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combo box
Try
=VLOOKUP($A$1,$A$3:$D$5,COLUMN(),FALSE) and copy across row "tom ossieur" wrote: would be happy with an answer on the below problem a friend has asked me to post, I believe there is an alternative, but also encounter a problem given: in cell A1 a list is created (data validation), referring to cells A3, A4, A5 A B C D 3 worst 12 12 13 4 base 12 15 18 5 best 12 16 21 In row 6 I want the data depending on the chosen scenario My solution: B6=VLOOKUP(A1,A3:D5,2) etc... however, the row is quite long, so that means that for every column I have to rewrite the formula... is there an alternative for this? QUESTION 2: why should one use a combo box in thes case? what is the advantage as compared to creating a list as described above? "tom ossieur" wrote: Hi, I intend to create three scenarios with each scenario incorporating two sets of variables (asset price and daily rate for example), and then use Combo Box to select a scenario. How can I do this? Thanks! tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |