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