IF statement help please

[golffinder]

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

 

[Bob Phillips]

Dave,

Try this

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

 

[Teethless mama]

Try it like this:

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