So what this is, is a list of transactions in Bank speak. And from those transactions I've taken common words that appear in them no matter what the variation. From there they are assign categories
Ex. bank speak = AMAZON.COM*1T9SS2M AMZN.COM/BILLWA (everything after the * may change, but the beginning is always amazon.com)
bank speak = AMZN MKTP US*03692 AMZN.COM/BILLWA (AMZN MKTP is always there)
These would both fall under the Amazon Category
Now what I want to do is have the bank spoken transactions go through their shortened version (amazon.com, AMZN MKTP) and have their category assign accordingly (Amazon). I know I could do this as a formula with a nested if, but that would be a big nested if, and I would really rather not.
I've tried using functions like Vlookup and INDEX/Match, but they would require me to reference the shortened versions to assign categories which doesn't work for how this is set up. As you'll see in the attached file.
I'm not asking ya'll to write my code, but if you could give me some reference or point me in the right direction. I know there is some way to do this in VBA.
Also I'm not an expert on VBA so some explanation may be required if you do supply code examples, just FYI.
Thank you,
Bookmarks