'Filter formula with 2 conditions

I am having a hard time figuring out how to get this to work on Google Sheets. I am trying to create a player pool based on the checkbox on a different tab. However, I want it to look for a checkmark, then look at the position, and then bring in the data.

Checkbox is in column A. Player position is in column H.

=if(and('Hitter Gameday'!A:A=true,'Hitter Gameday'!H:H="SS"),filter('Hitter Gameday'!B:X))

Thanks for any help anyone can provide!

google-sheets

Solution 1:^[1]

Try

=iferror(filter('Hitter Gameday'!B:X, 'Hitter Gameday'!A:A=true, regexmatch('Hitter Gameday'!H:H, "C.*")))

and see if that works?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1

'Filter formula with 2 conditions

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]