Column keyword search using list of keywords

I have a column of 5000+ cells, each containing one of a possible 40+ keywords. I need a program that will search each cell in this column, search the cell for one keyword, if any, of a list of 40+ keywords, and if a keyword is found, the keyword would be inserted into the adjacent, right cell. If I'm asking too much, let me know. I'm great with Excel, but I'm not a VBA programmer... so I am limited in my ability to manipulate mass data sets.

Ideas, anyone?

tshrader,

I can provide a VBA solution if required, but from your description VBA isn't actually necessary. You can use a helper column that contains your keywords, and then use that in a formula to see if the keyword exists. If it does exist, return the keyword. See attached example. The formula used is an array formula and thus should be entered with Ctrl+Shift+Enter.

Hope that helps,
~tigeravatar

Wow, that's awesome. I wasn't aware of this function. Thanks!