=IF(ISNUMBER(SEARCH Problem

Hi,

I'm trying to search a column for a part number. If it is present in that column then display Y. If it isn't display N.

I am using the following formula:

=IF(ISNUMBER(SEARCH("LRI8134/00",E5:E18)),"Y","N")

For some reason it is displaying N even though 'LRI8134/00' is present.

Any thoughts would be good

Cheers

Sam