Some help in ms excel

[007vaib]

I have got a list of about 50 names in an excel file. I need a way so that when in an another worksheet i press '1' the first name from the list gets typed, when i press '2' the second name and so on.
Please help.

 

[phuchungbhutia]

Try lookup fn or vba coding. Use help to understand

 

[neerajvohra]

probably you should check this or try finding your answer in this excel forum.

*www.mrexcel.com/forum/showthread.php?t=385637