Isnumber

[sburkhar]

You gave me the formula below which works fine for the populated rows.

IF(D17="","",IF(ISNUMBER(SEARCH("Terminal",D17)),"Term",IF(ISNUMBER(SEARCH("Wire",D17)),"Wire","Other")))

However, the unused rows have this in the reference cell:
=CHANGE MATRIX '!E27
This is returning "Other" on all the unused rows. So, in the example above D17 is not really empty.

I need the unused cells to remain empty of "Term", "Wire" or "Other"

 

[MrKowz]

What value is returned in the "unused rows"?

The formula you already have isn't testing for an "empty" cell, but is testing for a cell that does not contain a value - that way a truly empty cell, or a cell that contains the null character "", will return the proper statement.

 

[Joe4]

You gave me the formula below which works fine for the populated rows.

Who gave you this formula? If this is a follow-up on a question you already asked, you should post it back to the original question. That way, those who were helping you with this can see it and respond.

 

[sburkhar]

I did yesterday but nobody answered

 

[sburkhar]

No value is returned in the unused rows unless a previous tab is populated.
The cell appears empty but in reality has the ='CHANGE MATRIX '!E13 formula in it.

 

[Joe4]

I did yesterday but nobody answered

Then you can "bump" that thread again by posting back to it again (see Rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).