Combo Box - Reference Each Item to a Fromula

C

Chuck

Hi,

I have learned how to make a combo box with a list of
items, but how can I make each item in the drop down list
refer to a specific formula?

Example:
Competitors A, B and C are in my drop down list. Each
competitor has a specific formula I want to reference when
that competitor is selected. How do I get the results of
this formula to appear in the cell link?

Thanks very much for any help you can provide
 
Top