Isnumber search if

[Simont485]

OK so I have a formula that returns a true or false value for a certaintext string....

IF(ISNUMBER(SEARCH("EPN",B40)),"EPN","")

So if EPN is in B40 then EPN is shown in the cell where the formula is enteredotherwise it is blank. Works perfectly.

But

I now need to search a number!

IF(ISNUMBER(SEARCH("41",B40)),"41","")

Again it returns 41 or blank but

When B40 contains 412 or 4141 or any number containing 4 & 1 I still get a41 output.

How do I search for 41 only???

 

[tyija1995]

Re: Isnumber search if .......help needed!!

I'd probably just use an IF statement like so:

=IF(B40=41,41,"")

EDIT: Try this wildcard solution if you want ISNUMBER SEARCH combination:

=IF(AND(ISNUMBER(SEARCH("41",B40)),NOT(OR(ISNUMBER(SEARCH("?41",B40)),ISNUMBER(SEARCH("41?",B40))))),"41","")

 

[Simont485]

Re: Isnumber search if .......help needed!!

Too much over-thinking......many thanks!!