If 1 cell of range contains specific text

[bell_man]

Hi. I need a formula. If one of the cells H2,I2,J2 has the text "ADD" return the text ADD

Thank you.

 

[Cubist]

Try:

Book1
	H	I	J	K
1
2	ADD	NO	NO	ADD
3	ADD	ADD	NO	ADD
4	NO	NO	NO
Sheet1

Cell Formulas
Range	Formula
K2:K4	K2	=IF(COUNTIFS(H2:J2,"ADD")>0,"ADD","")

 

[bell_man]

OMG thank you. So simple. Not sure why couldn't figure that out.

 

[arthurbr]

An alternative

=FILTER(H2:J2,H2:J2="ADD","")