Forum Discussion
Help with my xlookup partial match formula
I have a list of clients from one database whose names need to be updated in another database to match, and their names are just slightly different from one another. I've been trying to run an xlooku...
This formula eliminates all letters and special characters from cell D16 and only returns the digits as text.
=TAKE(SCAN(D16,CHAR(VSTACK(SEQUENCE(47),SEQUENCE(198,,58))),LAMBDA(a,b,SUBSTITUTE(a,b,""))),-1)Then you can perform your XLOOKUP.
In one of the next updates, the REGEX() function will be added to Excel. This will make it very easy to extract numbers from text strings. But it is still beta.