If value is true the check column for specific values
 

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.

If value is true the check column for specific values
 

On Jan 22, 2:09*pm, MrPetreli
wrote:
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.

--
MrPetreli

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",""))