Using the ISNUMBER and SEARCH Funtions

[Michael N. Pierce]

If a value of 062914MNP-01 is in cell A2 for example, how can the IF, ISNUMBER, and SEARCH Functions be used to create a result in cell A1 of "Perfect" if true and "Error" if False if the part if the value of A2 contains the letters MNP. I tried =IF(ISNUMBER(SEARCH(A2,MKP)), "Perfect","Error" but the result is always Error.

Thanks, I am a novice at Excel.

Mike

[6StringJazzer]

First, check the definition of SEARCH; your arguments are backwards. Second, MKP should be MNP. Third, MNP should be in quotes.

Please Login or Register  to view this content.

[aavins73]

does this work for you..

Please Login or Register  to view this content.

[Michael N. Pierce]

Yes, that worked. Thank you very much. If you have an Animal Science questions, I will return the favor.

[Tony Valko]

Here's another one...

=IF(COUNTIF(A2,"*MNP*"),"Perfect","Error")

[6StringJazzer]

The solution from aavins73 assumes that the string MNP will occur in a specific position. That works in your example. Solutions from me and Tony Valkodo not make any assumptions about position.