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!