| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
