I have this dilemma,
On sheet 1 of my workbook I have a list of checking account transactions. It looks like a typical check register (Date, Description, Amount, Balance)
I would like to add a 5th column called Category. I want this column to use a formula that takes the Description text and compares it to a list on sheet 2 that has two columns: (KeyWord, Category)
The KeyWord column would have text values that might exist in the Description column from sheet 1. If a Description contains one of these values then the Category value from the list is returned to the Category column on Sheet 1
Sheet 1 might have a transaction with a description of
CHECK CRD PURCHASE 04/09 WELLS FARGO PREPAID SAN FRANCISCO CA 7020
Sheet 2 has the lookup list of
KEYWORD | CATEGORY
Wells Fargo | Credit Card
ATT | Phone Bill
So the formula should discover that the Description contains Wells Fargo and return Credit Card for the Category value. These Descriptions are coming from my online banking so they have date stamps in them and all sorts of extra text. I have to match on keywords within the description.
This seems to be very challenging scenario since I can't find anyone on the internet with solutions to it. If someone can solve this for me I would be extremely grateful!
On sheet 1 of my workbook I have a list of checking account transactions. It looks like a typical check register (Date, Description, Amount, Balance)
I would like to add a 5th column called Category. I want this column to use a formula that takes the Description text and compares it to a list on sheet 2 that has two columns: (KeyWord, Category)
The KeyWord column would have text values that might exist in the Description column from sheet 1. If a Description contains one of these values then the Category value from the list is returned to the Category column on Sheet 1
Sheet 1 might have a transaction with a description of
CHECK CRD PURCHASE 04/09 WELLS FARGO PREPAID SAN FRANCISCO CA 7020
Sheet 2 has the lookup list of
KEYWORD | CATEGORY
Wells Fargo | Credit Card
ATT | Phone Bill
So the formula should discover that the Description contains Wells Fargo and return Credit Card for the Category value. These Descriptions are coming from my online banking so they have date stamps in them and all sorts of extra text. I have to match on keywords within the description.
This seems to be very challenging scenario since I can't find anyone on the internet with solutions to it. If someone can solve this for me I would be extremely grateful!