Thread: 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

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

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