Forum Discussion

downekc09's avatar
downekc09
Copper Contributor
May 25, 2021

Formula needed to search in multiple sheets for a name, and if yes then sheet title will be listed

Hello!  I am not sure if such a formula exists in Excel... but this is what I would like to do...   I have an excel spreadsheet of employee training.  There are multiple sheets, all with the exact ...
excel
Formulas and Functions
downekc09's avatar
downekc09
Copper Contributor
Jun 01, 2021

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!

downekc09's avatar
downekc09
Copper Contributor
Jun 01, 2021
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.

Resources