Comparing data in a field to data in a table

[Adam]

I have hundreds of fields that contain names. I would
like to be able to compare the text fields against a
continually growing table that contains key words. If one
of these key words is found in the name fields, I would
like to find a formula to tell me a key word was found.

For example, A1 = "McDonald Corp."

I would then compare A1 against a group of cells (D150)
that contain key words that includes "Corp." in D5.
Since "Corp." can be found in A1, I would like cell A2 to
read "Corp."

Any ideas on how I could do this?

Thanks!