Hi There

I have a spreadsheet with 4 columns
A = Date
B = Description
C = Value / Amount
D = Lookup Column for matching with B

D has a long list of values like Burger King, McDonalds, Starbucks.
What I want to do is get the value from C where a word in B matches any of the words in D

Example
Column A
Date
01/01/2015

Column B
Description
POS W/D BURGER K

Column C
Amount
$20

Column D
BURGER K
MCDONALDS
STARBUCKS

requirement - return the value of C into column E

What I have tried is the following:
=IF(ISNUMBER(FIND("MCDONALDS",B2)),C2,IF(ISNUMBER(FIND("BURGER K",B2)),C2,0))))

The above works well but for every additional unique takeaway place I need to add an additional find and there is a limitation on the number of characters in the function.

Any ideas are really appreciated.
B