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