I’m in a flying squadron and utilize a long range schedule to commit members to events and shifts.

I’ve designed a schedule builder in one sheet, which searches other sheets for particular codes. Based on the code, that member is populated into a section of the schedule.

I’ve had no problem with this, but am now trying to expand the search to look for an additional logical expression.

See code below:

=iferror(query(ARRAYFORMULA(IF(INDEX(Pilots!$D$17:$140, , MATCH($B$2, Pilots!$D$1:$1, 0)) = "P1", Pilots!$D$17:$D$140, "")),"select * where Col1 is not null",0))

$B$2 is the date being selected on the sheet containing that line.
Pilots!$D$17:$140 is the reference.
Pilots!$D$1:$1 are the pilot names.
“P1” code defines the original (and first) logical expression.

I’d like to add a second logical expression to look in Pilots!$H$17:$140 to be TRUE (it’s a check box) in addition to “P1.”

I have not found a way to get it to work.

Attempted to apply help found here: https://support.google.com/docs/answer/3093301?hl=en