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 5 hours 50 minutes ago

Hi Tina

This is the forum to discuss questions about Microsoft Excel develop (VBA, customization). For your question is about formula in Excel, I am moving this thread to the TechNet forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards,

Lan