What formula to write - Vlookup or Index/Collect Formula???
I am creating a New Hire and CFO Buddy Tracker to assist me with paring new hires to mentors within the company.
I have two sheets set up one that has the name of all the mentors currently available and another with the list of New Hires.
The idea is that on the Mentor list I want it populate with the name of the New Hire they are assigned to on the New Hire List.
I have attached my sheet set-up below.
I have tried Vlookups and Index/Collect Functions but I get error messages.
Help Article Resources
Check out the Formula Handbook template!