Diving_Dan
Board Regular
- Joined
- Oct 20, 2019
- Messages
- 161
Hi all,
Having a few problems with a formula and hoping someone can help. I keep getting other as the result. If I remove the "or" portion of the formula along with two of the variables it works fine but as soon as I have them in it. Not sure what I'm doing wrong.
Thanks in advance
Dan
Having a few problems with a formula and hoping someone can help. I keep getting other as the result. If I remove the "or" portion of the formula along with two of the variables it works fine but as soon as I have them in it. Not sure what I'm doing wrong.
Thanks in advance
Dan
Excel Formula:
=IF(COUNTIFS(B24:B26,OR("EAST","WEST","SOUTH"),C24:C26,Lookups!A2)=1,"NOTED","Other")