If, or??

[CHC Consulting LLC]

Hi All

How do a write a formula for the following?

I am in cell B2

If cell A2 ends with "CCAP" or A2 appears anywhere in Column ZZ return "Yes"

Is this possible?

Thank you!

 

[Aladin Akyurek]

Try...

=IF(OR(COUNTIFS(B2,"*CCAP"),COUNTIFS(ZZ:ZZ,A2)),"yes","")

 

[CHC Consulting LLC]

Try...

=IF(OR(COUNTIFS(B2,"*CCAP"),COUNTIFS(ZZ:ZZ,A2)),"yes","")

Perfect, Thank you!!!!!!!!!!!!!!

 

[Aladin Akyurek]

Perfect, Thank you!!!!!!!!!!!!!!

You are welcome.