Why does this IF(OR(ISNUMBER(SEARCH find one item, but not the other?

[blbat]

=IF(OR(ISNUMBER(SEARCH("*UNIT RCVD/OnHand*", $R2,0)), ISNUMBER(SEARCH("TN0*",$R2, $R2)),ISNUMBER(SEARCH("TN1*", $R2, 0))),"UNIT", "relook")

This Formula will find the "TN0*" string within the cell R2, but will NOT find the "TN1*" string.

what am I doing wrong...or am I going at this the wrong way?

(R2 contains a sentence (String) of text, dates and numbers in the one cell.)


regards,

blbat

 

[jimrward]

For TN0 why have you got R2 twice in the search

 

[blbat]

TYPO...sorry

=IF(OR(ISNUMBER(SEARCH("*UNIT RCVD/OnHand*", $R2,0)), ISNUMBER(SEARCH("TN0*",$R2,0)),ISNUMBER(SEARCH("TN1*", $R2, 0))),"UNIT", "relook")

 

[blbat]

found it...I didn't need the ",0" after $R2

SOLVED