I'm trying to classify a cell [G1] based on particular words found within 2 columns [D1 & E1]. This classification copies down from [G1] down to [G20]
Basically, I've got 10 different classification options. If a particular word within [D1 & E1] matches a word in an array in my classification tab, the result in cell G1 should be the header of the classification tab [Option X].
Option 1 Option 2 [Option 10]
Henk Aap ..
Bert Noot ..
For example: If D1 is "Henk eats a carrot", cell G1 should be "Option 1".
- Ideally it would be a dynamic formula ignoring blanks. So someone can add/remove any classifications in the classification columns
- In some occasions a classification only works when 2 conditions are satisfied, for example: "Henk eats a carrot with Aap", meaning the following line is added in the total formula: