searching an array from a column set of text and returning a value..

[bebop1337]

Sorry if this was reposted but I couldnt find something I needed exactly..
Basically I have a column for key words I need to search for, Column A and a column for return values on those key words, column B
on column C I have a text array that will have one of those key words on column A.
I need to: 1) search column C and identify which keyword appears from column A and 2) return the cooresponding column B

For example, column A will have: cat, dog, ferret, chicken, column B will have catreturn, dogreturn, ferret return, chicken return
column C will have 1248cat5667, hxyefhferret56, ineedtogetadog435. I need column D to return catreturn, ferret return, dogreturn

Let me know if you need any more clarification!
Thanks so much guys!!!!

[bebop1337]

so to clarify, I need column D do do some sort of a look-up in column A based on column C, find the particular value in A and return corresponding value in column B...

[bebop1337]

issue.jpg
need to return column D

[Tony Valko]

Try this:

=LOOKUP(1E100,SEARCH(A$2:A$5,C2),B$2:B$5)

Copy down as needed.

[bebop1337]

thank you so much thats exactly what i was looking for!

[Tony Valko]

You're welcome. Thanks for the feedback!