Thank you. Will this work to essentially "lookup" the manager, who's name may not be in the same room in each sheet. If in 2000 you had a higher payroll than me and my team, you would appear ahead of me. If the following year Joe's team moved from #10 highest in 2000 to the highest payroll in 2001, Joe would appear ahead of both of us. I'll try your proposed solution shortly. What if different managers joined and others left? Simple example of having managers in different order attached.