Trouble with INDEX/XLOOKUP

Good day!

I've written a formula (probably quite chunky) to search and compare different cells and return a value if matches found. I have a calendar with clients and week numbers. What is supposed to happen is it searches the data exported from an outlook calendar, matches that info to the client and week number, and if we have a meeting during that week number, return a value of "y" (just so I can do some conditional formatting). My problem is that if there are multiple meetings that week, it only populates one of them, if any at all. I'm not sure how to go about fixing it.

Screenshot 2023-06-14 133115.png

My formula is:
=IFERROR(IF(AND(INDEX('Outlook Calendar Info'!$G:$G,ROW(XLOOKUP($F$5,WeekNumbers,WeekNumbers)))=$B7,YEAR(INDEX('Outlook Calendar Info'!$E:$E,ROW(XLOOKUP($F$5,WeekNumbers,WeekNumbers))))=2023),"y",""),"")


Any Ideas?

You have trouble with XLOOKUP, but XLOOKUP is not available in Office 2010. Please update your MS-Off Ver in your profile.

I can not edit a picture of your screen.
Please upload a sample sheet. See yellow banner at the top of the page.

Please try in F7 and copy right and down:

Formula:

Please Login or Register  to view this content.

Thanks for your feedback, Glad to have helped.

Please consider adding reputation to any helpers you think they deserve.
In that case please click * Add Reputation left below their answers.