Hello,

I’m trying to populate an interactive calendar with dates that a team member will be working. I have been using the XLOOKUP function to do this and can get it working for a single date. Ideally this needs to be a variable date range as I dont want to have to manually input a new formula into the calendar each time. Can XLOOKUP search multiple ranges? I.e searching to see if the date on the calendar matches either cell $B3:$B4 &:$D3:$D4 and then populating the calendar with the persons name?

current formula is as follows : =XLOOKUP(D8,Sheet1!B3:B23,Sheet1!E3:E23)

Screenshots attached.

​Hello, I’m trying to populate an interactive calendar with dates that a team member will be working. I have been using the XLOOKUP function to do this and can get it working for a single date. Ideally this needs to be a variable date range as I dont want to have to manually input a new formula into the calendar each time. Can XLOOKUP search multiple ranges? I.e searching to see if the date on the calendar matches either cell $B3:$B4 &:$D3:$D4 and then populating the calendar with the persons name? current formula is as follows : =XLOOKUP(D8,Sheet1!B3:B23,Sheet1!E3:E23) Screenshots attached.   Read More

​