Nest IF/IFS with OR and FILTER function On Drop Down Boxes

Hi All,

I've attached a workbook to further demonstrate my problem & my intended aim with this.

What I need:
I need a formula that uses drop down boxes to populate information in another part of the worksheet based on it's selection. It sounds straightforward but it has a few moving parts to it.
First, I need the formula to bring back all Entry ID's relating to the Senior Manager, which then gets broken down further by Team Manager (I want the formula to rely on the OR statement here by showing the Senior Managers results first then if the filter has been selected for a Team Manager, then their results then show. If the Team Manager is deselected, then it reverts back to Senior Manager entries again (Until at least another selection is made for a different manager). I also need the formula to be clever enough to filter by days as well, so if an entry ID goes back 60 days, then it will bring back this criteria too.

What I've tried (Please also see workbook example):
=IFS(K17<>" ",FILTER('Raw Data'!F:F,('Raw Data'!J:J=K17),IFS(H17<>" ",FILTER('Raw Data'!F:F,('Raw Data'!K:K=H17),IF(N17="All",FILTER('Raw Data'!F:F,('Raw Data'!K:K=H17)*('Raw Data'!J:J=K17),""),FILTER('Raw Data'!F:F,('Raw Data'!K:K=H17)*('Raw Data'!J:J=K17)*IF(N17="passive/detractor",('Raw Data'!Z:Z="detractor")+('Raw Data'!Z:Z="passive"),('Raw Data'!Z:Z=N17)),0))))))

Why this doesnt work:
It returns entry_Id numbers as expected but the function to only bring back Senior Manager entries only isn't working because I have prioritised the formula for the Team Managers first. I get the same problem if I switch the formula round with Senior Managers being prioritised first. I also cannot get the date function right because this drop down boxes change but do not return anything within that date range, it's like it's being ignored completely. Example workbook has a #REF error but not too clear why yet.
I've kept the cells in the same position that I have it in my live sheet.

Key things which may help:
The drop down boxes are pre-populated with data from another tab altogether using UNIQUE formulas - not included here because these work fine with the formulas, I just cant get all of it right.
I'm using Excel with 365 capabilities, Enterprise version - so I should have all the latest functions. Arrays work without needing to do Control+Shift+Enter.
I've tried to search for a query answer on various forums but cannot find one bespoke enough to my request but feel free to re-direct if I have missed anything.

Any questions please let me know,
thanks again in advance for any help.

Craig.

Thanks for this, the 1st video helped somewhat for dependent drop down lists but her method for executing returned values based on drop down didn't quite give me what I needed (Although I will watch it again later just to be sure I've not misunderstood it) - It was an interesting way of doing dependent drop downs without relying on the UNIQUE statement.

E19 needs to display the output based on the drop downs from H, K & N17. So if Senior Manager 1 from the raw data was the only drop down selected, it would return his/her results
but if we decided to select a manager under this senior leader, then it would then filter their results (results being Entry_ID from raw data).

The corresponding output is based on the 2nd tab in the worksheet (Raw data), in column F as per the formula.
So if Senior Manager 1 is selected, then all the row adjacent to column F with that senior manager has those results returned.
Does that make sense?

Thank you that worked a charm based on 1 drop down - any chance the formula can be expended to include Team Manager as well from column J in the raw data? Thank you

Thank you, it's working as intended - I just spent some time changing the drop down boxes and comparing the output against the raw data (so the adjacent cells with Senior Manager 1 as example, brings back 1234565, 1234568 & 1234570 whereas because I filter further by Team Manager 1, admittedly it brings back 2 IDs instead of just the one expected however that was my fault because this team manager had more than 1 senior manager assigned, which wouldn't happen. So I'd safely say the formula is working as intended & I will now mark as resolved. A big thank you for your help, really appreciate it