'For Google Sheets/Excel, how can a name/text be entered n a column, and auto-populate a different name in a separate column?

I am looking to make a spreadsheet containing employee names and managers. I want to be able to enter an employee name in Column A and automatically have their manager's name populate in Column B. I



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source