Combo boxs

D

DenisN

Is it possisble to pick an item from a comb box and instead of a value
appearing in one cell hav three different values appear in three
different cells.

Pick a ward from combo box and in three different cells
hav

Breakfast lunch Tea
 
T

travismorien

I don't know if there is a way to directly accomplish this with a combo
box, but you could achieve the same effect easily enough, if there are
only a few possibilities, Lunch and Tea could be responses from an IF
statement.

=IF(A1="Breakfast","Lunch",IF(A1="Another combo result","Something
different"))

Nest a few of those if you have more alternatives.

If its more than a few IFs, I'd use vlookup, take the cell A1 (which in
this case is "Breakfast") and look up breakfast in the table to see
what goes next to it. So B1 and C1 would use the following formulae:

=vlookup(A1,[range with a few options corresponding to the combo
items],2,false)
=vlookup(A1,[range with a few options corresponding to the combo
items],3,false)

Travis
 
P

paul

you would have to use travis's approach where the combo box triggers a lookup
or if statement
 
Top