If one cell isnumber, and another has text,..

[Steve]

I have text in cell a1, including, but not limited to (FLM):
If I have a number, either 1 or 0 in cell B1
I need cell C1 to show FL if A1 contains FL
And D1 to show M if A1 contains M

A1 B1 C1 D1
abcdefg(FLM) 0 FL M

Thanks,

Steve

 

[Bernard Liengme]

In C1 use: =IF(ISERROR(FIND("FL",A1)),"",IF(OR(B1=0,B1=1),"FL",""))
In D1 use: =IF(ISERROR(FIND("M",A1)),"",IF(OR(B1=0,B1=1),"M",""))
best wishes

 

[Steve]

Worked like a charm. Thanks so much.

Steve

In C1 use: =IF(ISERROR(FIND("FL",A1)),"",IF(OR(B1=0,B1=1),"FL",""))
In D1 use: =IF(ISERROR(FIND("M",A1)),"",IF(OR(B1=0,B1=1),"M",""))
best wishes