linked cell

[sfphen]

I have two lists. Column A is Alpha, Bravo, Charlie, etc. Column B is A, B, C.
What I want to do is have someone choose, from a dropdown, a choice from Alpha, Braveo, etc and then the cell next to it will be A, or B, etc...How do I get the toher cell to populate with the A or B when I choose the Alpha or Bravo from the dropdown?

[EdMac]

Use the LEFT function e.g. in B1

Please Login or Register  to view this content.

will give you the first letter from A1