Cell link in a form listbox - can it show a word?

J

Jim

When I make a listbox with a range of words instead of numbers, the listbox
shows the words but the cell link cell shows 1 if it is the first word, 2 if
second, etc. Is there a way to make it show the word in the cell link?
Thanks
 
D

Dave Peterson

You can use a helper cell to translate that number to the words.

=index(rangeofwords,linkedcell)
 
Top