Forum Discussion
Formula needed to search in multiple sheets for a name, and if yes then sheet title will be listed
downekc09 I ended up figuring something out! I have a tab with "All" info (I get it online from an account that creates it, then I sort by training). Then I have separate tabs for each training that automatically update from the "All" tab with the names, expiration dates, if qualified, etc. Then I have another "Training List" tab that lists each training and hyperlink to that specific training tab. The last tab I made is the "Employee" tab which is the one I was having trouble with and figured out a couple formulas! I have a drop down list of each employee name. When a name is selected, a list of their trainings show up. I made it so that if "John Smith" is found in this training tab, then the title will be listed. Then I used conditional formatting to "white" out the "FALSE" results.
Thanks!
- The reason I wanted to make it this way was to make it user friendly for some of the employees here. If they want to see a specific employee's training, they use the "Employee" tab, and if they want to see who all has First Aid training, then they use the "Training List" tab and click on First Aid. I also added a Home hyperlink on each tab that goes back to the "Training List" tab.