Excel 2007: Extract Text String based on a Defined List of Criteria

[justr8hr]

Hello guys,
Please help this newbie.
I want to search the vendor/Text String (from bank statement)on the list below.

KEEP THE CHANGE TRANSFER TO ACCT

POS #209700 AMERICAN RANCH 12-28 CUSTOMER 1311 PURCHASE ARTESIA CA

STARBUCKS CORP 12/29 PURCHASE 2 SANTA MONICA, CA

ID:BX0364457 IDS PROPERTY CAS DES: PREM

POS 4457311483 MACY'S EAST 483 12/29 CARD PURCHASE CERRITOS, CA

TARGET -30 CUSTOMER PURCHASE #007924 Cerritos CA

CARLTON HAIR INTERNATIO 12/28 CARD PURCHASE

KEEP THE CHANGE TRANSFER TO ACCT

POS CSMC CAFETERIA4007 12/27 PURCHASE

<tbody>
</tbody>

Initially I am doing this manually. I have decided to document my input so I don't have to input them one by one, only if I just know to use them as reference to automatically extract the text.
Here is My criteria list (the actual one is more comprehensive)

VENDOR	KIND/CATEGORY
American Ranch	Groceries
Anthem Blue	Health Insurance
Autozone	Car Repairs
Carlton Hair	Personal Care
Cheesecake Factory	Meals
Chevron	Fuel
CSMC CAFETERIA	Restaurants/Dining

<tbody>
</tbody>

Once I am able to extract the text based on the criteria, I can then put the right category.
VBA or Excel solutions will be greatly appreciated
Thanks a lot!

 

[justr8hr]

PROBLEM SOLVED!!!! Kudos, hiker95. Your VBA eventually worked. I experimented a bit and found that in order for the code not to return an error is that the target criteria string must have the same case and structure as the extracted text. Wohoooo!!!

 

[hiker95]

justr8hr,

Thanks for the feedback.

You are very welcome. Glad I could help.