Good day,

This is my first time posting so please be kind if I'm breaking any rules here.

I'm creating a spreadsheet that will use drop-down lists. The first worksheet is name form and contains the drop-down in cell A2. The second worksheet is named lists, in which I've entered values as follows: A2 1-soccer, A3 2-hockey, A4 3-baseball. I've named the list of A1:A4 as "list" and linked it to the drop-down on the "form" worksheet. Ok, here's the question, when I click the drop-down, is see 1-soccer, 2-hockey and 3-baseball; what I want to happen is when I select hockey, the value displayed in "form A2" is 2. Is this possible?

I hope that makes sense.

Thanks,
Dave