A fromula to pick up nontext in cell

[chris]

I 2 columns, A & B. I have data in colunm a cells that are text but the text
varies from cell to cell, over in some of the cells there is the words
INACTIVE. I want a fomrula that will look to colunm A and return the inactive
text into column B else if the colunm is not INACTIVE return blank cells.
hint I tried VLOOKUP, IF THEN, ISTEXT and no luck. Please HELP!!!

chris

 

[Bob Phillips]

=IF(A1="INACTIVE",A1,"")

or is that too simplistic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Chris Lavender]

or, if there's other text in there as well as INACTIVE

=IF(ISERR(FIND("inactive",A1,1)),"",A1)

Best rgds
Chris Lav