Custom value for List Box

[nick2price]

Hi, I created some data like so.

Please Login or Register  to view this content.

I wanted to create a list box which displays the letters A-G. The Yes and No values next to each letter is the value for that letter. I didnt want to do this through Data Validation because I prefer the way a Form Controls List Box looks.

Anyway, using Form Control, I drew out a List Box. For the Input Range, I set it to be the column containing the letters A-G. Is there any way to now associate their value with this? If I set its Linked Cell to the cells containing Yes or No, when I change the list option a number displays e.g. 2 when B is selected. So I need a way to make this 2 display Yes instead using a Form Control.

Is this possible?

Thanks

[mehmetcik]

The linked cell will show A to G

So convert that to a number from 1 to 7 using

Please Login or Register  to view this content.

Then use a formula to convert that number to Yes/No

in your scenario

Please Login or Register  to view this content.

In a complex environment the choose function is useful

Please Login or Register  to view this content.