Dave,

Try this

=IF(COUNTIF(B2:B5,"*"&E1&"*")0,"YES","NO")

--
__________________________________
HTH

Bob

"golffinder" wrote in message
...
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