I am trying to find a function that will tell me if a row in Column A contains ANY of the data in each cell in Column B and have the Yes/No be entered in Column C. For Example:
Column A Column B Column C
DogCatHorse Rabbit YES
PigDeerChicken Dog NO
BirdFishRabbit Cat YES
Is there a formula of some kind to accomplish this. So for this, the 2nd row in Column A is a no because “Rabbit”, “Dog”, or “Cat” is not found anywhere in the data of that cell.