| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
