Vba code for index match array formula in excel

    Hi,


    I want a VBA Macro Code for the following formula:- =INDEX(Brand_NameCategories,MATCH(TRUE,ISNUMBER(SEARCH(BrandKeywords,$I1)),0))


    I have a list of descriptions and i have a master of keywords which help me tag each description to a keyword using this formula.


    Your help will be appreciated !

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login