Excel Says ‘No Match’? You’re Not Using the “Anything” Symbol
Автор: KR8
Загружено: 2026-02-06
Просмотров: 308
Описание:
Excel says “No Match”… even though the value is clearly right there?
You’re not using Excel’s “Anything” symbol: the asterisk (*).
In this video, you’ll see how one small symbol controls how Excel matches, searches, counts, and even formats data, and why so many “no match” errors happen in the first place.
What you’ll learn:
✔ Use the asterisk inside Excel filters to match partial text
✔ Count and clean literal asterisks without breaking formulas
✔ Fix XLOOKUP “no match” errors using wildcard search
✔ Make searches dynamic (no more editing formulas)
✔ Why wildcards fail on partial numbers (and the fix using &"")
✔ Use the star in custom number formats to mask sensitive data
0:00 Excel says “No Match”
0:19 Filter search with the * symbol
1:03 Literal * vs wildcard
1:47 Cleaning * with Find & Replace
2:08 Fixing XLOOKUP “no match” with *
3:08 Partial number search
4:01 Bonus: formatting IDs with *
4:46 Different uses of *
🔔 Subscribe for weekly Excel + AI hacks. Hit the bell icon to get notified about our latest videos!
#exceltips #xlookup #wildcards
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: