Hi i have a one problem please see the details below, i have attahced the sample file as well.
i have thousand of search term and i need to categories them in to intend. so i used if sumproduct and if search formula by adding few key strings i wanted to look into. and that works fine,
Problem:
what i want to do is that if there is some way where i can embed vlookup or any other other formula which can help me look 1000's of competatior in to search term column and look partial part of it give me a value in text "competitor"
Is there is any way to look into it.