Home > Mobile >  google sheets: filter results based on multiple filters, across a row-column search
google sheets: filter results based on multiple filters, across a row-column search

Time:12-12

In Entries Sheet, I have rows with Date, Note, and Number columns

In Reports Sheet, I'd like to show a filtered list of Notes based on the Date and Number columns from Sheet 1.

I've added notes to the enter image description here

UPDATE

=IFNA(
  QUERY(
    BYCOL({1,2},
      LAMBDA(
        offset,
        INDEX(Entries!A2:ZZZ,,MATCH(B1,Entries!1:1,0) offset))),
   "select Col1"&IF(B2="",," where Col2 = "&B2)))

enter image description here

  • Related