Hey all,
I've got this list of Employee ID - Employee Name - MGR ID - Manager Name. 1400 employees, ~400 managers.
I'm looking for a formula or function or feature - SOMETHING that will allow me to populate the Manager ID. I know VLOOKUP would work if it was a 1:1 relationship but as the...