A fromula to pick up nontext in cell
 

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

A fromula to pick up nontext in cell
 

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

or is that too simplistic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chris" wrote in message
...
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

A fromula to pick up nontext in cell
 

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

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

Best rgds
Chris Lav

"Bob Phillips" wrote in message
...
=IF(A1="INACTIVE",A1,"")

or is that too simplistic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chris" wrote in message
...
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