Need to chck if a keyword is present in a text string and return keyword if yes

Put this array* formula in B2:

=IF(MAX(IF(ISNUMBER(SEARCH(E$2:E$6,A2)),ROW(E$2:E$6)))=0,"",INDEX(E:E,MAX(IF(ISNUMBER(SEARCH(E$2:E$6,A2)),ROW(E$2:E$6))))) & IF(MAX(IF(ISNUMBER(SEARCH(F$2:F$6,A2)),ROW(F$2:F$6)))=0,"",INDEX(F:F,MAX(IF(ISNUMBER(SEARCH(F$2:F$6,A2)),ROW(F$2:F$6)))))

then copy down.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual Enter.

Hope this helps.

Pete

EDIT: Sorry, you won't be able to use the full-column references in the arry formula as you have XL2003 - try this one instead:

=IF(MAX(IF(ISNUMBER(SEARCH(E$2:E$6,A2)),ROW(E$2:E$6)))=0,"",INDEX(E$1:E$6,MAX(IF(ISNUMBER(SEARCH(E$2:E$6,A2)),ROW(E$2:E$6))))) & IF(MAX(IF(ISNUMBER(SEARCH(F$2:F$6,A2)),ROW(F$2:F$6)))=0,"",INDEX(F$1:F$6,MAX(IF(ISNUMBER(SEARCH(F$2:F$6,A2)),ROW(F$2:F$6)))))

Still committed with CSE.

File attached to demonstrate.

Pete