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?