Forum Discussion
How to allocate rows from one tab to another based off similar text?
Hi, Curious to know if there's a easier way to automate this process or if the only method is manual Basically, as seen in my attached sheet, i have tab 1 with a "masterlist" of brand petrol statio...
I ran 3 different XLOOKUPs on your data.
- Standard XLOOKUP - 287 returns
- XLOOKUP using Regex match mode (This looks for the text anywhere within the string) - 300 returns
- XLOOKUP w/Wildcard match - 300 returns
If you're using a fully updated Excel 365, you'll have access to the 2nd option. I've included all formulas in the attached. I hesitate to try a partial matching without Regex because then it becomes a matter of how much of the text do we use to match and it can result in false matches.