Hello,
I'm have a table tracking relationships between Mentors and Mentees (see the attached table). I would like to input a mentee name in cell F2 and return everyone mentoring that person in the following column (G2 downward).
Any thoughts? I suspect it is a complicated series of matching and indexing.
Bookmarks