This function uses the syntax FILTER(array, include ... Let’s complicate things a bit by adding more display and filtering values. Enter the function =FILTER(B3:F13,(D3:D13=I4)*(E3:E13=I5 ...

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion.