Excel 2007 : Return a value based on a list

No matter. Assuming the list of strings you want to search for is in column I, and you want to return the search string if it's found, or the original string if it's not, then try this:

Formula:

=IFERROR(INDEX($I$2:$I$4,MAX(IF(ISERROR(SEARCH($I$2:$I$4,A2)),-1,1)*(ROW($I$2:$I$4)-ROW($I$2)+1))),A2)

BTW: It's an array formula, and you MUST confirm with Ctrl+Shift+Enter, and not just Enter.