olayo
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