• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to assign category using two keywords from different columns in Excel


New Member
I have two columns to look at from my data that I can pull different key word combinations to generate a specific category. I think that if I can have a different list in another sheet to define what the two keywords that create the category, I can achieve it and be able to place a column will be able to identify each category by referencing the second sheet that will act as a key. I think I would use INDEX MATCH. This problem is very similar to the one linked, however, I have two key words from different columns to generate a particular category. Similar Question