A fromula to pick up nontext in cell

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
 
B

Bob Phillips

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

or is that too simplistic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you change Cell name reference from R[-2]C[-1] back to C2 2
Pick the low number in a column of Numbers 3
returning the value in Colunm C using Colunm A as Ref 1
formula to search and find item sheet1 copy to sheet 2 1
"If" Problem 2
Look up and return a value 1
VLOOKUP QUERY 6
Copying hyperlink from one cell to another within a formula 1

Top