XLOOKUP, Partial Match Level 4

Welcome to XLOOKUP Level 4 in the Excel Hack series 🔥

In this short video, I show how to use wildcard matching in XLOOKUP to find values even when you only have partial text.

For example, if your list contains Amazon Inc and you type only Amazon, XLOOKUP can still find the correct revenue using * ⚡

📌 Formula used:

=XLOOKUP(B3&"*",B7:B21,C7:C21,,2)

💡 How it works
&"*" adds wildcard match
,,2 enables wildcard mode
Returns the matching revenue ✅

✨ Example:
Amazon → Amazon Inc → Revenue Found

🎥 Continue learning with the full XLOOKUP Level 1 → Level 5 series 🚀

More Excel tips:
www.youtube.com/@tejasanalytics

#Excel #XLOOKUP #ExcelTips #DataAnalytics #LearnExcel #ExcelShorts #Wildcard

Видео XLOOKUP, Partial Match Level 4 канала Tejas Shinde | Data & Analytics