Result from a combo box
 

I have a speadsheet with a combobox in it and 4 items.

When I select an item from the list, I want the value to be displayed in
another cell...all I seem to get is the index of the item selected (e.g.1st
item selected, 1 is diplayed in the result cell).

Is there anyway to get the actual data to display in another cell when an
item is selected?

Thx

Result from a combo box
 

Use INDEX function to get the value from combobox list depending on the
selected index number.