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
5	dssdd	dssdd
6	dssddXXXXjklz	next step

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell Formula L5 =IF(ISERROR(SEARCH("XXXX",K5)),K5,"next step") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

[/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.