If with Match and multiple cells

Hello,

I use this forum all the time for help, but this is my first post.

I am not very good with creating formulas and functions myself, but I can usually find one with similar results and modify it for my use.
After several hours of searching and modifying, I am stumped and hope someone can help.

In range L2:AK2, each cell will have a value entered from a dropdown.
If any of these cells contain the value Disagree or Strongly Disagree, I need cell F2 to have an N as the value.
If these values are not found, I need F2 to remain blank.

I appreciate the help!

Try placing this in F2:


=IF(COUNTIF(L2:AK2, "Disagree")+COUNTIF(L2:AK2, "Strongly Disagree")<>0, "N","")

This also helps me. Thanks!

Both of these work perfectly!
Thank you so much!

=IF(OR(SUM((L2:AK2="Strongly Disagree")*1)>=1,SUM((L2:AK2="Disagree")*1)>=1),"N","") Control+Shift+Enter

Originally Posted by Pepe Le Mokko

Why should an array formula be needed and why use multiple functions when 2 are sufficient?

You are right. Sometimes I am not able to see easier solutions. But this is first solution what came to my mind at that moment.
In this site I always get surprised of smart and short formulas you guys give.

Thanx and sorry:

Sorry I used more than two functions..

Clearly that was the best solution I could think of, there's no need to heckle us. If the OPs doesn't like our formulas, they are more than welcome to not use them.