I am in need of some help with a very cumbersome spreadsheet that is currently being used to track completed employee training. Here's how it's set up: each employee has their own tab -> listed on each tab is the description of their completed training (i.e. January 5 - Regulation D Webinar). I work at a bank and the regulators like to see a compilation of who attended each training session. Right now, the person in charge of compiling these training records is having to manually go in and look for "January 5 - Regulation D Webinar" in each person's tab.
Here's my question: Is there a formula, or combination thereof, that will look in a specific range of cells for the "January 5 - Regulation D Webinar" text, and if it's found, return a value that is the employee name? I've tried various IF, MATCH, IFERROR, INDEX functions and have even tried to combine some to no avail. Any help would be much appreciated as I think I'm starting to go cross-eyed researching formulas! Thank you!
Bookmarks