Help With Drop-Down List Results

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

Hi
You could VLOOKUP to achieve this.
Firstly on your Lists worksheet in column B add the number from the values in your list.
Then use VLOOKUP on the forms Worksheet in cell A2:
=VLOOKUP(A2,Lists!A:B,2,FALSE)
This will return just the number you want to display.
Good luck.
Tony

Tony,

I attempted to put the formula, you so kindly provided, into my example worksheet with no success. I've attempted to upload my simple example workbook, that I'm using until I understand the way it works. Once I get that down, I'll include it on my actual spreadsheet. Can you take a look at it and see what I'm doing wrong?

Dave.

Hi Dave

Cut and paste the following formula into cell C2 of your Form Sheet.
=VLOOKUP(A2,dropdownform.xls!twocolumns,2,FALSE)
Come back if you still have issues. I have tested it in your copy of the Workbook.
Tony

Hi Dave
In a word "No" .
As we are using A2 for the drop down list box you cannot then ask it to display only a portion of its source data once you have made your selection.
If you can give me a fuller explanation of your end requirement there may be other options we can explore.
Look forward to hearing from you.
Tony

Tony,

That's what I thought, but if you don't ask........

Thanks for all of your help. The vlookup will work for what I want to do.

Thanks again.