Hi, I created some data like so.
A | Yes
B | Yes
C | Yes
D | Yes
E | No
F | No
G | No
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