Categorize credit card transaction details by predefined buckets (e.g. gas, food, entertainment, etc.)

[JamesonMH]

Hi folks,

I want to do a pivot table based on credit card transaction data that is categorized - obviously the raw transaction data won't make for a very good pivot table since it's not categorized... When downloading a credit card stmt in csv I get transaction data something like below (blank fields not relevant):

A	B	C	D	E
Card #	Trans. Date #	Posting Date	Amount	Description
			100	ABC Car dealership
			25	#123 Woolmart
			50	XYZ Gas Mart
			125	ABC Restaurant
			75	ZYZ Liquor Store
			100	Costking #1234
			40	Lot ABC Parking
			15	Mcdavid's #56568
			80	ABC Auto Park

<tbody>
</tbody>

I want a lookup formula that allows me to put everything into say 1 of 5 predefined buckets (i.e. fast food, auto, entertainment, department stores, other) so I can then do a pivot table that's clear.

"other" would just be a catch all for things that didn't match anything in the master table.

So based on my predefined master table, if the transaction description field contained the word "Costking", it would go under "department stores". And "ABC Car dealership" would fall under "Auto" (since my master table would have Auto next to Costking.

Any ideas?

Thanks
James