• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I need help with a formula


New Member
I have a list of employees with their hire and training dates for different departments. I need to use a drop box, select the date and department and populate the required fields in the second worksheet (dashboard). I know we can use a combination of index, match and row but I don't know how I can put them together ( I did index and match but when I select different month and department, the old employee population from the previous selection was not removed from the list, it needs to be refreshed for the new month and dept. selection). Thanks a lot.



Active Member
Your thread title is extremely poor - practically everybody here needs help with a formula!!!

Provide a mock-up of what you want with results entered manually.


Check this Formula Solution, Works fine according to your requirement.