Hi, I have created and used drop down lists but I want to do something more with a drop down list.
Basically when I drop down my list and choose a selection I want to put a corresponding value into a different cell.

ie. My list could be as follows on sheet 2 (leters in column A, numbers in column B)
The letters A through D are named for my drop down list
A 1
B 2
C 3
D 4

On sheet one I create my drop down list with the A through D list.
Now when I choose say 'A' from the drop down I would like the number 1 to go into a different cell, or B would get the number 2 and so on.

Can anyone tell me how to do this in excel?

Thanks