Need expert Help!!

[Dushyant]

Hi All,
Need your expertise to solve the below problem.
My data look like this:-

Column A
Outlook 2003 Win32 EN
Outlook 2003 Win32 EN
Outlook 2003 Win32 EN
Windows Mail for Win Vista AL
Outlook Express 6.0 Win32 EN
Office 2003 Win32 EN
Outlook 2003 Win32 EN
Office Enterprise 2007 HUP AL
Outlook 2003 Win32 EN
Office Small Business 2007 ML


Column B
Excel
Word
Powerpoint
Publisher
Infopath
Netmeeting
Access
Frontpage



Search for any of the string in column B which is present in Column A.For
example search "Office" in col. A, "Excel" and so on.For every value that is
found the next cell should display "office" or else "Outlook".......

...Is it possible .. any formulae or VBA (Macro)

any help would be highly appreciated..




Thanks
Dush