If value is true the check column for specific values

[MrPetreli]

Hi

I need a formula to check if a column contains specific values it th
column contains a certain value

if column A:A = string "ABC" then check A:A for string "123" & "456". I
"456" is missing then display list missing string in cell b2

 

[zvkmpw]

Hi

I need a formula to check if a column contains specific values it the
column contains a certain value

if column A:A = string "ABC" then check A:A for string "123" & "456". If
"456" is missing then display list missing string in cell b2.

The following formula seems to get the right answer for the stated
example, but I get the feeling there's more to it than that.

=IF(COUNTIF(A:A,"ABC")=0,"ABC",
IF(COUNTIF(A:A,"123")=0,"123 ","")&
IF(COUNTIF(A:A,"456")=0,"456",""))