Excel 2007 : Finding substrings in a string

Hello,

I want a formula that will look at a string and find one of several possible substrings, then output the matching substring.

Example:

String (Column A)

yellow

Valid Substrings (Column B)

llo
ang
lue
re

The formula should return "llo" for yellow.