I’m working on a calendar in google sheets and mapping different shipping scenarios. I want one cell to surface the day of the week something is delivered by looking for “Box Delivery” in the range and then checking 1 OR 2 rows above for the day of the week (as it could be in either). I have a formula that is working to check one row above but it isn’t working for two rows above.

=IFERROR(
    INDEX(
        C11:I11,
        1,
        MATCH(TRUE, ISNUMBER(SEARCH("Box delivery", FLATTEN(C12:I15))), 0)
    ),
    IFERROR(
        INDEX(
            C11:I11,
            1,
            MATCH(TRUE, ISNUMBER(SEARCH("Box delivery", FLATTEN(C11:I14)))), 0
        ),
        ""
    )
)

this also worked to pull the day of the week from 1 row above but not 2

=IFERROR(
  INDEX(
    C11:I11,
    1,
    MATCH(TRUE, ISNUMBER(SEARCH("Box delivery", FLATTEN(C12:I15))), 0)
  ),
  IFERROR(
    INDEX(
      C11:I11,
      1,
      MATCH(TRUE, ISNUMBER(SEARCH("Box delivery", FLATTEN(C12:I15))), 0) - 1
    ),
    INDEX(
      C11:I11,
      1,
      MATCH(TRUE, ISNUMBER(SEARCH("Box delivery", FLATTEN(C12:I15))), 0) - 2
    )
  )
)

Any chance someone can clue me in on how to get the formula to display the day of the week whether it’s one or two rows above “Box delivery”? Thank you!