Try the Fuzzy Lookup in Excel instead of the XLOOKUP function.
🚀 Take our Data Analyst Program here: https://www.careerprinciples.com/care...

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...

Fuzzy lookup tutorial in Excel. The XLOOKUP is arguably the most powerful function in Excel, but there's a better alternative for matching values called fuzzy lookup. In this tutorial I show you how to use the xlookup matching for exact matches and partial matches with the wildcard feature, as well as the xlookup limitations. Once we understand that, we go over the solution of using fuzzy lookup in power query, as well as installing it as a separate add-in inside of Excel.

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
🚀 All our courses: https://www.careerprinciples.com/courses

SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok -   / career_principles  
🧑‍💻 LinkedIn -   / careerprinciples  

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ XLOOKUP Exact Match
0:53​ - XLOOKUP Partial Match
2:04 - Problem with XLOOKUP
2:40​ - Fuzzy Lookup
5:15​ - Fuzzy Lookup in Excel
8:46​ - Power Query vs Excel Version