combo box linked cell value

Not sure I understand your question. The "LinkedCell" in the Combo box property should reflect what was chosen. The Combo box will list everything that is in the "ListFillRange".

Sorry, I wasn't clear.
the combo box displays all the options. after one is picked the linked cell displays a number corresponding to the option that was chosen. i need the linked cell to display the value of the option.
for example assuming the options are

dog
cat
pig

when the "dog" is chosen the box would display "dog" and the linked cell would display 1. i need the linked cell to display dog as well.
is there a way to do it?

Ania,

The way you constructed your Combo Box would not be appropriate for that. If you need to use the selected value in some formula (e.g., in a VLOOKUP formula as a lookup value), you can use the INDEX function to access the value selected thru the Combo Box.

First give a name to the range that houses your items via the Name Box on the Formula Bar, eg., List1. Then use:

=INDEX(List1,linked-cell-ref)

Usage in a VLOOKUP formula would be:

=VLOOKUP(INDEX(List1,linked-cell-ref),a-table,....)

Aladin

===============

In the ComboBox Properties, go to "BoundColumn". If Dog, Cat ect is in the first column, make sure the value is set to 1. If it's in the second column, change this to 2 etc.

Thanks, Aladin!!

Thanks!