Pull In Managers Manager (rows are not using hierarchy)
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!
Best Answer
-
Thank you, @Sameer Karkhanis - that did it!
Answers
-
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")
-
Thank you, @Sameer Karkhanis - that did it!
Help Article Resources
Categories
Check out the Formula Handbook template!
