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
--
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
--
DenisN
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
you would have to use travis's approach where the combo box triggers a lookup
or if statement
--
paul
remove nospam for email addy!
"[email protected]" 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks