Forum Discussion
Find value in matrix based on today's date in column
I have a matrix with a date sequence =SEQUENCE(1;366;(DATE($D$6;1;1));1) in the columns and names (text) in the rows. I would like to write a formula that matches three search criteria: (1) ...
dangreen755 You can use FILTER() function.
=FILTER(B3:B8,(A3:A8="Manager")*((FILTER(C3:F8,C2:F2=TODAY())="Duty")))XLOOKUP() should also work.
=XLOOKUP(1,(A3:A8="Manager")*(XLOOKUP(TODAY(),C2:F2,C3:F8)="Duty"),B3:B8,"")See the attached file.
dangreen755 You can use FILTER() function.
=FILTER(B3:B8,(A3:A8="Manager")*((FILTER(C3:F8,C2:F2=TODAY())="Duty")))
XLOOKUP() should also work.
=XLOOKUP(1,(A3:A8="Manager")*(XLOOKUP(TODAY(),C2:F2,C3:F8)="Duty"),B3:B8,"")See the attached file.
Excellent Harun24HR.! Thank you for your fast response.
