Excel How To use Wildcard with XLOOKUP and FILTER

preview_player
Показать описание

This video shows how we can use wildcards (partial matches) with the XLOOKUP and FILTER functions.

Chapters in this video:
00:00 - Introduction
00:11 - XLOOKUP
00:51 - Wildcard
02:05 - FILTER

Also, check out these videos with time saving Excel Hacks:

Рекомендации по теме
Комментарии
Автор

Love the clear, succinct, no-nonsense style

worldofinterest
Автор

Great tutorial! Newbie question: I keep getting #SPILL error even though there's only one of this value in the table. Any ideas?

brittbernatchez
Автор

Excellent! Exactly what I needed to find all smiths, how include SMYTHE ? sm*th ?

mbmokuw