Hi everyone, Ive been pulling my hair out over this for the past two hours & have resorted to making an account so I could query you guys directly. Hopefully I can get either a solution or new input into what I'm trying to do and an alternate solution.
Any help is sincerely appreciated!
I'm looking for a formula that will pull a word from a cell, based on a set of words, if it's present in that cell. If that makes sense? So lets say I've flagged words like "KFC", "Visa", "ATM" if any one of those words are present in a cell they will appear in the cell my formula is based in.
What I'm trying to do & Why.
I'm trying to create a personal expenditure report for my bank account. The idea I have is I can download an excel version of my statement from the bank & paste it into an excel workbook. This workbook will have a vlookup in it that will total up transactions based on their reference. So lets say I go to KFC twice a month the reference that appears on my bank statement will be POS KFC, so I can create a vlookup that will search for that reference and give me a total for the month that I've spent in KFC. I could do the same thing for ATM withdrawals, Groceries, my Rent, my Light & Heath, etc. and ultimately have an automatic report built of what I've spent my money on that month. The issue I'm having is with the referencing on my bank statement. The cell that contains reference for the store I've spent money in or bill m paying also has a date in it which will kill my vlookup. I have an example below of the reference that appears on my bank statement;
ATM BRAY2 30/01 11:17
POS KFC - CARRIC 27/01 1
POS SUPERVALU 26/01 11:0
POS MICROSOFT 25/01 09:4
I was thinking I could run a formula connected to each of those cells that will search them for words like "ATM", "KFC", "Supervalu", "Microsoft" etc and if any one of them is present the word will appear next to the cell. I can then run the vlookup for those words and not have to worry about the date.
Any ideas guys? I'm pulling my hair out. Using a formula like RIGHT or LEFT won't work because the words in the cells are different sizes.