Good Morning everyone!
Thanks for taking the time to try and help. I very much appreciate it.
This has been a rather constant headache for a few weeks. I am attempting to create a training tracker in which reports can be ran based on multiple criteria. Currently, it is setup with VLOOKUP formulas and a drop-down menu to pull the data to helper cells, then charts which are directed to that data to automatically populate based on which training is selected in the menu.
However, what I need to it to, is to be able to run reports based on multiple criteria. Say, Training Topic, Department and Hire Date. Ideally, it would only pull the data from the "Training Data" tab that matched all 3 of those criteria, this limiting the graph to only training completed on this topic, on this day, with this department.
I have looked into index-match formulas, but it appears that those are not going to work as it pulls one piece of data based on multiple criteria. (i.e First Name, Last Name and DOB returns the salary of that individual) I need it to pull all data in the list that matches the criteria in such a way that the graph can utilize it. Is this simply outside of the capabilities of excel? I've already succumbed to the fact that I'm probably going to have to completely rework this sheet one way or another so any insight into the issue or solution would be much appreciated.
Here is the excel sheet if you would like to see what I am talking about. https://drive.google.com/file/d/18MtCGXq3IRDAiA5UiRu0bqFdb6kwKKJy/view?usp=sharing
Thanks!
Chance
Thanks for taking the time to try and help. I very much appreciate it.
This has been a rather constant headache for a few weeks. I am attempting to create a training tracker in which reports can be ran based on multiple criteria. Currently, it is setup with VLOOKUP formulas and a drop-down menu to pull the data to helper cells, then charts which are directed to that data to automatically populate based on which training is selected in the menu.
However, what I need to it to, is to be able to run reports based on multiple criteria. Say, Training Topic, Department and Hire Date. Ideally, it would only pull the data from the "Training Data" tab that matched all 3 of those criteria, this limiting the graph to only training completed on this topic, on this day, with this department.
I have looked into index-match formulas, but it appears that those are not going to work as it pulls one piece of data based on multiple criteria. (i.e First Name, Last Name and DOB returns the salary of that individual) I need it to pull all data in the list that matches the criteria in such a way that the graph can utilize it. Is this simply outside of the capabilities of excel? I've already succumbed to the fact that I'm probably going to have to completely rework this sheet one way or another so any insight into the issue or solution would be much appreciated.
Here is the excel sheet if you would like to see what I am talking about. https://drive.google.com/file/d/18MtCGXq3IRDAiA5UiRu0bqFdb6kwKKJy/view?usp=sharing
Thanks!
Chance
