I wanted to check if the teams this year have played in all the five previous years. I've attached a spreadsheet to show you what I've done. What I'm doing isn't working which is why I'm asking for help. I've used the function below.
B2 would be the team names cell.
The thing is that I had it working only for the bottom 3 teams at one stage but I know there are more teams that qualify.
Any help gratefully received.
Regards to all.