XLOOKUP with Regex in Excel

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


This video shows how to use regex patterns with the XLOOKUP function to provide tons of flexibility when doing lookups. Specifically:
- XLOOKUP warm-up
- XLOOKUP with regex match (match code 3)
- XLOOKUP with REGEXTEST

Chapters in this video:
00:00 - Introduction
00:13 - Exercise 1
01:19 - Exercise 2
04:13 - Exercise 3

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

  1. Excel University
  2. excel tips and tricks
  3. excel formulas
  4. excel functions
  5. combine data in excel
  6. microsoft excel
Рекомендации по теме
XLOOKUP with Regex 0:08:17

XLOOKUP with Regex in Excel

'REGEX Match' Examples 0:05:36

'REGEX Match' Examples for Excel's XLOOKUP Function - The Super-Powered *Wildcard* Al...

Excel Adds Support 0:03:28

Excel Adds Support For RegEx In XLOOKUP And XMATCH - Episode 2647

New Regex Modes 0:00:43

New Regex Modes for XLOOKUP and XMATCH in Excel 365 #shorts

Introducing REGEX Excel 0:19:22

Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)

Xlookup Formula with 0:00:45

Xlookup Formula with Regex Pattern | Only 10% Excel User Know This Method | Must Watch

Better than XLOOKUP? 0:11:39

Better than XLOOKUP? Try SUPERXLOOKUP!

Avoid this Costly 0:09:27

Avoid this Costly XLOOKUP Mistake in Excel

Excel RegEx Support 0:07:00

Excel RegEx Support For Pattern Matching - Episode 2642

XLookup Wildcard Match 0:02:42

XLookup Wildcard Match in Excel

How to find 0:00:34

How to find the MAX using XLOOKUP in Excel‼️ #excel #exceltips #spreadsheets #tutorials

Enable use of 0:00:44

Enable use of regular expressions (RegEx) in Excel

Microsoft Excel - 0:05:55

Microsoft Excel - New REGEX Functions are Amazing!

9 Essential REGEX 0:16:22

9 Essential REGEX Formulas in Excel

Does XLOOKUP in 0:02:00

Does XLOOKUP in Excel not work with certain special characters? (2 SOLUTIONS!!)

Extract Multiple Email 0:02:50

Extract Multiple Email Addresses using the New REGEX Function in Excel

Determine Cause of 0:17:11

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. E...

Excel 365 Basics 0:49:21

Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!

Everyone's Talking About 0:09:29

Everyone's Talking About This NEW Excel Function (TRIMRANGE)

Excel de ÇAPRAZARA 0:01:03

Excel de ÇAPRAZARA (XLOOKUP) içinde REGEX kullanımı

Does XLOOKUP in 0:02:38

Does XLOOKUP in Excel not work with certain special characters?

Get the last 0:07:11

Get the last populated Cell in a Column using XLOOKUP in Apple Numbers

12 - Using 0:11:30

12 - Using RegEx in Excel (VBA)

FUZZY LOOKUP in 0:00:58

FUZZY LOOKUP in Excel 365

Комментарии
Автор

Love the channel, but really wish you made your sample Workbooks available for download!

jerrydellasala
Автор

Thanks, nice explanation. Re wildcard: instead of typing (*) all the time, what about "*" & C6 & "*" by default?

kkravch
Автор

I'm not using excel for a while but I have a question. You said, Regex option is new but XLOOKUP is available even in Excel 2021. After this update, the XLOOKUP function in Excel 2021 also updated as including Regex option?

Sekoleyte
Автор

What other alternative I have for example 3 if I don’t have regex

lizzrodriguez
Автор

So we can use filter drop-down select 875 without formula? Right?

cgr
Автор

a have Q =TEXT(DATE, "MMM") BLANK CELL JAN NEED TO BE BLANK

NasserHabeeb-ewfv