Pull In Managers Manager (rows are not using hierarchy)

chrishallo_Charter

Hello, Community! I could use some help with a formula. If Worker or Manager were using hierarchy, it seems like it would be more straightforward. So, what I'm trying to accomplish is a formula to pull in the Managers' Manager. In the below example, the person in Manager is the VP, the name in Worker is under him (so 01 and then 02 as the Org Level because I'm using that in other metrics widgets). In the Test column though for the other 250+ names, I want to pull in who a Worker's Manager reports to (their manager). I tried Index/Collect but not sure if that's 100% the correct or most efficient method.

Any help would be greatly appreciated :)...and thank you!

chrishallo_Charter

Thank you, @Sameer Karkhanis - that did it!

Sameer Karkhanis

Do you have a master sheet where every employee's manager data has been captured Or does this sheet itself has that? Assuming the later you can try,

=IFERROR(VLOOKUP(Manager@row, Worker:Manager, 2, false), "No Manager Found")

chrishallo_Charter

Thank you, @Sameer Karkhanis - that did it!