Hi All,

I have a number that goes 12824PM12. The PM stands for material so I have a formula that looks for the PM and returns the word "material".

That works fine.

I also have numbers with just P in it, for example 1234P5

I wanted to use the same formula to look at the cells with just P in and not PM but it doesn't seem to work.

The formula I use to look for PM is

=IF(ISNUMBER(SEARCH("PM",G2)),"Material","")

By changing the PM to P it will look at everything with a P. How do I get it to ignore a cell with PM in it?