Home

Formula Help!

%3CLINGO-SUB%20id%3D%22lingo-sub-1132895%22%20slang%3D%22en-US%22%3EFormula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132895%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20someone%20can%20help%20me%20as%20I%20am%20tearing%20my%20hair%20out%20trying%20to%20figure%20a%20formula%20that%20can%20do%20this!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20formula%20that%20would%20read%20IF%20Column%20A%3AA%20%3D%22Dog%22%20%26amp%3B%20Column%20B%3AB%20%3D%20%22Red%22%20If%20true%20%22Yes%22%2C%20If%20false%2C%20%22No%22%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20Column%20A%3AA%20%3D%22Cat%22%20%26amp%3B%20Column%20B%3AB%20%3D%20%22Blue%22%20If%20true%20%22Yes%22%2C%20If%20false%2C%20%22No%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20do%20so%20on%20and%20so%20fourth!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20is%20below!%20any%20help%20is%20much%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20579px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167674i7DE5D3E4FC229154%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Example%20Image.PNG%22%20title%3D%22Example%20Image.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1132895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133144%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133144%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535711%22%20target%3D%22_blank%22%3E%40Knoxy_93-%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStarting%20in%20cell%20G2%3A%3C%2FP%3E%3CP%3E%3DIF(COUNTIFS(%24A%242%3A%24A%2416%2CG%241%2C%24B%242%3A%24B%2416%2C%24E2)%2C%22YES%22%2C%22NO%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133162%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%20That%20is%20great!!%20Thank%20you%20so%20much!%20I%20was%20totally%20over%20complicating%20things!%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1133219%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1133219%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535711%22%20target%3D%22_blank%22%3E%40Knoxy_93-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20pleasure!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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
Highlighted

Hello @Knoxy_93-,

 

Starting in cell G2:

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

Highlighted

@PReagan 

 

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

Highlighted

@Knoxy_93- 

 

My pleasure!

Related Conversations
Need some help figuring out edge://sync-internals/
HotCakeX in Discussions on
0 Replies
Notifications from Planner in Teams
nwehl in Microsoft Teams on
0 Replies
Embedded Sharepoint List - Custom Forms not loading
sbayer in Microsoft Teams on
0 Replies
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Adding Wiki Tab Issue
goatscandrum in Microsoft Teams on
1 Replies