Try it like this:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(E1,B2:B500))),"YES","NO")


"golffinder" wrote:

Hi
Can anyone help me with this, I want to search a range of cells say
B2:B500 a value such as 6523 that is in E2. B2:B500 is made up of a
url with an id number at the end and i want to compare colum E to find
which i have missing or extra from those in colum B, i have this =IF
(ISNUMBER(SEARCH(E1,B2:B500)),"YES","NO") but not working

thanks

Dave