=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:

Please Login or Register  to view this content.

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

Any thoughts would be good

Cheers

Sam

Try:

Please Login or Register  to view this content.

SEARCH is used within a specific cell, not a range.
Try COUNTIF

=IF(COUNTIF($E$5:$E$18,"*LRI8134/00*"),"Y","N")
Does that work for you?

EDIT: I assumed the cell might contain more than the part number and used wildcards "*"