Error in search

[negi]

Hi
i am using the formula but its not working. request you to please help me.

=IF(SEARCH("index",A4,1)>1,"Index",IF(SEARCH("incre",A4,1)>1,"Index","Non Index"))

 

[VoG]

Try

=IF(ISNUMBER(SEARCH("index",A4)),"Index",IF(ISNUMBER(SEARCH("incre",A4)),"Index","Non Index"))

 

[villy]

What exactly do want here?
Are you trying to search for the word "index"?

 

[negi]

yes Mr Villy

 

[negi]

"index" is the word and search from the row

 

[VoG]

Did you try my suggestion?

 

[villy]

Have you tried the formula of VoG I think it does the same thing but...
If you are looking after a cell not a range it could be like this..

=If (A4="index","Index",If(A4="incre","Not index","Not in Choices"))

if you are searching within range then you should specify a range.

 

[negi]

thanka a ton mr vog
its work