Help, Trying to get Fields to auto populate

Hi There, I have a spreadsheet set up which i use to track amounts of times we reject cases, What i am trying to do is instead of having to type a persons name and then find there respective manager i want to type the persons name and then the respective managers name is automatically populated in the next field.

I cannot find away to do this.

I have a list of peoples name and there respective manager on another sheet within the same excel file.

Any help would be grateful.

so example of what i am wanting is. If C1 is "Example Example" it returns in C2 "Test Test"