Index/Match with 2 Criteria Not Working

Hello all,

I have an excel sheet I am working where I am trying to match the room number and check-in date to the person who cleaned it. On sheet 'Medallia' the two matching criteria are found in columns A and B and will populate the response in column H. Sheet 'Cleaner' will match to room number and date and return the housekeepers name.

I've tried using index and match and for some reason I can not get it to return a value. I know that it should as I've tried multiple rows and I know a match exists. Any help you can provide will definitely be appreciated!

Thanks

Because in sheet CLEANER's column date stored as DATE+TIME format (equal to xxxxx.xxx) while in sheet MEDALIA date values stored only in DATE format (equal to xxxxx.00).
Excel store date as number (integer) and it's time as decimal which is 24 hr is 1.
So you have to convert CLEANER date value with formula something like INT or QUOTIENT to get it's number only without decimal = DATE only.