• 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

    Hui...

  • 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

Alex_a

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.
 

Attachments

AliGW

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.
 

Juniad

Member
Check this Formula Solution, Works fine according to your requirement.
=IFERROR(INDEX(Data!B$2:B$30,SMALL(IF((Data!$D$2:$D$30=$I$3)*(MONTH(Data!$E$2:$E$30)=MONTH($I$1)),ROW(Data!$B$2:$B$30)-ROW(Data!$B$1)),ROWS($B$6:B6))),"")
 

Attachments

Top