I am creating a work sheet using formulas and drop down list. I have one drop down list that has a list of name and the second list is a list of letter that correspond to those names. (ex: column "J" on line "4 - 29" there is the letter "A-Z" and then continues , in column "K" line "4" starts the list of names. In Cell B4 is the drop down list of names in column "K" to choose from, I would like the letter that corresponds to that name automatically be put into cell A4, how do I create the formula in cell A4?

• Moved by Lanlan HuangMicrosoft contingent staff Wednesday, April 15, 2015 1:39 AM

Hi Tina,

According to your description, please following these steps:

1. With your sample as shown in the following figure, select range J4:K29, and click FORMULAS-Defined Names-Create from Selection, and check Right column.
   
2. Then, use the enter formula in A4 =INDIRECT(B4).

And I upload a TEXT.xlsx file on OneDrive, you can download this file via this link:

https://microsoft-my.sharepoint.com/personal/v-lzng_microsoft_com/Documents/Shared with Everyone

Hope its helpful.

Regards,

Emi