Hello
I have made an example of my problem below where I want to match data/ get to know if it exist in a group, separated by an empty cell. All "groups" are put in the same row and have a header. How can this be done by formulas?
How can I confirm if Header1 has cat?
How can I confirm if Header2 has train?
The data and the number of rows will change everytime I do a new match/ lookup:
Example:
Column A
Header1
car
train
cat
dog
Header2
cat
train
Header3
car
dog
train
I have made an example of my problem below where I want to match data/ get to know if it exist in a group, separated by an empty cell. All "groups" are put in the same row and have a header. How can this be done by formulas?
How can I confirm if Header1 has cat?
How can I confirm if Header2 has train?
The data and the number of rows will change everytime I do a new match/ lookup:
Example:
Column A
Header1
car
train
cat
dog
Header2
cat
train
Header3
car
dog
train