How to associate an employee name with the name of their supervisor?

[copelcod000]

Excel noob here. Each week I have multiple spreadsheets where my sole task is to alphabetize them by employee name and to manually insert their supervisors name next to them. This is incredibly time consuming for me. How can I make it so entering the employees name will yield their supervisors name next to them regardless of cell location; employee name in A1 would insert their supervisors name into B1, but I could do that same employee in A20 and their supervisor would appear in B20.

 

[marcelita03]

Google "VLookup examples", there are millions of videos in You Tube on the different Vlookup applications. You will need a list with all the employees names next to their supervisors.

 

[Joe4]

Welcome to the Board!

Create a lookup table of employees and their supervisors, then you can use the VLOOKUP formula to do what you want.
See: MS Excel: How to use the VLOOKUP Function (WS)