Row/Column Comparison Help

Hello all,

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.

By: Josh

Leave a Reply

Your email address will not be published. Required fields are marked *