A fromula to pick up nontext in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(A1="INACTIVE",A1,"")

or is that too simplistic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
or, if there's other text in there as well as INACTIVE

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

Best rgds
Chris Lav
 
Back
Top