I think this is a really simple problem but I am struggling to find the right method/function.
I have a Google spreadsheet with a sheet called “Calandar” which is just a column of each day of 2024, starting at 01/01/2024, and ending on 31/12/24.

[https://docs.google.com/spreadsheets/d/1zNgzM0jJd84Pi_Z6rGK7qyMfX7qGMRkbpf4fIYpnhEE/edit?usp=sharing]

The second sheet is called “Data” and this is where the team members record the event type and the date they want.

I need the “Calandar” sheet to compare the dates and insert the events in the correct rows according to the dates supplied in “Data”, and I need this to be automatic.

I have researched the xlookup function but I want to compare the whole range Calander!A2:A366 against the range Data!B2:B, and return the record in the corresponding column in Data!A2:A.
Nothing I have found seems to compare the range to the range – and then the duplicate dates in Data!B2:B are a problem too.