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.
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)))