Lookup key words in bank statement description

I would like to lookup key words in my bank statement descriptions in order to categorize the transaction.

Here is an example of the Descriptions I will search in (Cell C2)

BURGER KING #9905 08/31 PURCHASE MARLBOROUGH MA
THE OLIVE GARD00016261 08/31 PURCHASE MARLBOROUGH MA
BIG Y 29 HOLDE 09/02 PURCHASE HOLDEN MA

Will be using the below table to search for the first field (Cell $I$2) in order to return the second field (Cell $J$2)

Burger King	Fastfood
Olive	Dining
Big Y	Groceries

I am using below formula now
=(IF(ISNUMBER(SEARCH($I$2,C2)),$J$2,IF(ISNUMBER(SEARCH($I$3,C2)),$J$3,IF(ISNUMBER(SEARCH($I$4,C2)),$J$4,IF(ISNUMBER(SEARCH($I$4,C2)),$J$4))))

But this list is getting way to big.
Is there a better way to create a lookup table which I can expand easier?

Try upload your file and example of your requirement, click on Go Advanced" button then scrolling down to find "Manage Attachments" text button to attach the file



regards