I use this loooooong formula to check if data in cell A33 is have regexmatch pattern from cell INDEX('categories'!$A:$A;1;1) - cell A4 - if its true, I use regexreplace patterm from cell INDEX('categories'!$B:$B;1;1) - cell B4. If its not - I go and check the next cell with regexmatch pattern - ('categories'!$A:$A;2;1) - cell A5. And do it until I find right pattern, or until reach the last cell A30 which have pattern A30 ="^.I use this loooooong formula to check if data i