XLOOKUP but wrong results?!?

About

👋 Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. ✅ Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep ✅ New Video Every Week ~ Subscribe 💻📗 My courses Advanced Excel 👉 https://chandoo.org/wp/excel-school-program/ Advanced Power BI 👉 https://chandoo.org/wp/power-bi-course/ Everything 👉 https://chandoo.org/mdac ~ KNOW 😀 About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW 🚶‍♀️🚶‍♂️ 🌐 Website - https://chandoo.org/wp/ 📃 FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ 📚 Courses - https://chandoo.org/wp/training-programs/ 📷 Instagram - https://www.instagram.com/chandoo.xlsx/ 💥తెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/