Formula Help!

Copper Contributor

I hope someone can help me as I am tearing my hair out trying to figure a formula that can do this! 

 

I am looking for a formula that would read IF Column A:A ="Dog" & Column B:B = "Red" If true "Yes", If false, "No" 

IF Column A:A ="Cat" & Column B:B = "Blue" If true "Yes", If false, "No" 

 

And do so on and so fourth!

 

Example is below! any help is much appreciated! 

 

Many thanks :) 

 

Example Image.PNG

3 Replies

Hello @Knoxy_93-,

 

Starting in cell G2:

=IF(COUNTIFS($A$2:$A$16,G$1,$B$2:$B$16,$E2),"YES","NO")

@PReagan 

 

Thanks for the reply. That is great!! Thank you so much! I was totally over complicating things! :D 

@Knoxy_93- 

 

My pleasure!