Forum Discussion
Autopopulate formula across worksheets?
I am trying to create a lunch schedule for the year with approx 30 people. Each day a new person will be chosen (with their initials on Picture 1), and then it will automatically rotate (s...
For each output table, first look up the appropriate row of the schedule by name, Then selected dates corresponding to non-blanks. Finally transpose results to column.
= LET(
personSchedule, XLOOKUP(person, names, schedule),
scheduleDates, IF(ISTEXT(personSchedule), dates, NA()),
TOCOL(scheduleDates, 3)
)