ExcelBanter - IF statement help please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF statement help please (https://www.excelbanter.com/excel-worksheet-functions/236912-if-statement-help-please.html)

golffinder

IF statement help please

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[_3_]

IF statement help please

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

Teethless mama

IF statement help please

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

All times are GMT +1. The time now is 08:24 AM.