Combo boxs
 

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

Combo boxs
 

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

Combo boxs
 

you would have to use travis's approach where the combo box triggers a lookup
or if statement
--
paul
remove nospam for email addy!



" wrote:

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