Auto population between two dropdown columns on same sheet

Trying to see if there is a way to have two different dropdown columns auto populate one another when selection is made. One column would be an account name and the other would be it's corresponding account number. This will be for around 200 different accounts, so the less manual data entry the better.

Answers