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

[@excelisfun]

Thanks, Mr Excel!!!!!

[@suatmozgur]

Thanks, Bill! Great new feature!

[@rnunez047]

¡Gracias!

[@GeertDelmulle]

Hey Mr.Excel, why don’t you put the QAT below the Ribbon?

[@MrXL]

I lose two rows of the grid! On my main monitor, I go from 37 rows to 35, a 5+% reduction.

[@montmraaa]

RegEx functionality would be useful in the SUBSTITUTE function.

[@GeertDelmulle]

One of the new REGEX functions does exactly that. :-)

[@AnandPenmatcha]

Filter function needs regex

[@MrXL]

Yes! I thought that would be a great one. Although your could sort of use REGEXTEST in the Filter by argument....

[@sledgehammer-productions]

that was also what came to my mind, because: what if there are two orders for Kiwis in Los Angeles.... 🤔xlookup will only give you one.