Help with filter combined with 3 indirects

[malaki1974]

Hello, I have a working filter that looks like this:

=filter('2022'!A:E,('2022'!D:D=B1),('2022'!C:C=C1))

I tried converting to also use indirect so that I could make a filter that I could change with a dropdown with matching years for tab names.

=filter(INDIRECT("'"&B5&"'!A:E"),indirect("'"&B5&"'!D:D=C1"),indirect("'"&B5&"'!C:C=D1"))

I am not able to figure out the formatting for adding indirects to this.

Can anyone assist?


Bonus: I need the filters to work if some of them are blank also

 

[Fluff]

Your 1st formula is not valid. Do both columns have to match, or just one?