XLOOKUP with Regex in Excel

[@PaulEBrownbill]

Very interesting, thanks

[@jerrydellasala7643]

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

[@mghayadar]

Thank You.

[@icelcaoili5262]

Thank you!

[@goodman-it2qy]

Thanks

[@ZmanKC]

Great video, thank you.

[@ExcelU]

You bet!

[@yousrymaarouf2931]

Fantastic

[@lizzrodriguez1850]

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

[@kkravch]

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

[@NasserHabeeb-ew3fv]

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