If(isnumber(search

[surkdidat]

How do I amend the code in

IF(ISNUMBER(SEARCH"XXX" ...etc

so if it ISNT "XXXX" please

 

[sheetspread]

Change isnumber to iserror?

 

[Aladin Akyurek]

What is your input string in which you look for XXX only?

 

[surkdidat]

Apologies, I rushed the post as I had to go off to a meeting!!

I have

IF(ISNUMBER(SEARCH("XXXX",K5)),K5,........

However, I want it to look at the value in K5, and if it does not contain XXXX then I want it to display that value, if it contains XXXX, I need it to move onto the next part of my logic

 

[sheetspread]

Like:

Excel 2010
	K	L
5	dssdd	dssdd
6	dssddXXXXjklz	next step
Sheet5

Cell Formulas
Range	Formula
L5	=IF(ISERROR(SEARCH("XXXX",K5)),K5,"next step")

 

[surkdidat]

Hi there

It needs to CONTAIN "XXXX" so this can be anywhere in the text in the relevant field....[

QUOTE=sheetspread;5029051]Like:

Excel 2010

	K	L
dssdd	dssdd
dssddXXXXjklz	next step

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

</tbody>

Sheet5​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L5[/TH]
[TD="align: left"]=IF(ISERROR(SEARCH("XXXX",K5)),K5,"next step")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[/QUOTE]

 

[Aladin Akyurek]

If the target in K5 must contain "XXXX", then:

=IF(ISNUMBER(LOOKUP((9.99999999999999E+307,SEARCH("XXXX",K5)),"next step",K5)

If the target in K5 must NOT contain "XXXX", then:

=IF(ISNA(LOOKUP((9.99999999999999E+307,SEARCH("XXXX",K5)),"next step",K5)

Note that these will not distinguish between XXXX and XXXXX.