Problems others posted on before, merchants lookup and rename.
I added a clean merchant name field in the transactions sheet, works great!!
Adding merchant name manually when I classify transactions weekly works well!!
Creating a simple vlookup works as well to automate with formula!!
Problem is many merchants now called by store number or amzn .com vs. mkt vs…
Writing a long formula works but there has to be a simpler way.
Is there a way to create a reverse vlookup. meaning that there is a table that hold the regex expression
Where the second column has the clean name
lets call this table merchantlookup
Then I need to do reverse match where the description in transactions sheet is used as the full text field and I match each entry in the merchant lookup table against the description and where there is a match the value from column B is placed in transaction tab in the clean merchant column.
There has to be a simple formula that I am missing.