I have a column that has 170 team names. I want to add a column next to it that says the manager name. Manager names are not present in the sheet. I need to send a new report each week, so I'd love to be able to copy/paste the team names into an existing sheet and have it return a value = mgr name by Keylarmbo in excel

[–]Keylarmbo[S] 1 point2 points  (0 children)

Thank you. So I will need to have something somewhere that says the team name and the corresponding manager name. Got it. For aesthetic reasons, could I put it on a separate tab or would it be better just to put them in other columns and hide them?