# 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

• 10.5 KB Views: 6

#### 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.

#### GraH - Guido

##### Well-Known Member
Some alternatives given, I hope you can all see them and use them.
1. Slicers on the table
2. Pivot with timeline+slicer
3. formula solution

#### Attachments

• 33.3 KB Views: 7

#### Alex_a

##### New Member
Thank you so mucj Grah-Guido. Wonderful options. All options work!

##### 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

• 13.4 KB Views: 8