VBA code - IF(ISNUMBER(SEARCH("Adobe", $A4)),"Adobe Pro")

Hi all,

I am having issue creating some vba code for following formula:

Column A (Software) | Column B (Formula)

Adobe Acrobat 9 Standard | Adobe Pro
Adobe Acrobat X Pro - English, Français, Deutsch | Adobe Pro
Dreamweaver11 | Not required
Microsoft Office Professional Plus 2013 | Office Pro
Microsoft Office Project Standard 2010 | Project
Microsoft Office Standard 2010 | Office Std
Microsoft Office Standard 2013 | Office Std
Microsoft Office Visio 2010 | Not required
Microsoft Project Standard 2010 | Project
Microsoft Project Standard 2013 | Project
Microsoft Visio Professional 2010 | Visio
Microsoft Visio Viewer 2010 | Not required
Microsoft Visio Viewer 2013 | Not required


My code:

Please Login or Register  to view this content.

I seem unable to make it work.

Please assist

Please Login or Register  to view this content.

Thanks for your reactive replies AB33, I seem able to make it worked as follows


#############

Please Login or Register  to view this content.

#################

Many thanks again for your tips