Jan 28 2020 05:02 AM
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 :)
Jan 28 2020 07:44 AM
Jan 28 2020 07:57 AM
Thanks for the reply. That is great!! Thank you so much! I was totally over complicating things! :D