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) today’s date (column D in the picture), AND (2) the value ‘Duty’ in the matrix, AND (3) the value ‘Manager’ in column A. The return value in the example should be “Carl” (B7).
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) today’s date (column D in the picture), AND (2) the value ‘Duty’ in the matrix, AND (3) the value ‘Manager’ in column A. The return value in the example should be “Carl” (B7). Read More
