Using FIND formula with 3 FIND?

[marreco]

hI.
I can use this separate function, you could use them together?

=IF(ISERROR(FIND($S$1,J9));$R$1;IF(ISERROR(FIND($S$2,J9));$R$2;IF(ISERROR(FIND($S$3,J9));$R$3;"Not Find)))

Thank you!!!

 

[Robert Mika]

Try if this work:
=INDEX($R$1:$R$3,MATCH("*"&J9&"*",$S$1:$S$3,0))
or if there is no match at all
=IFERROR(INDEX($R$1:$R$3,MATCH("*"&J9&"*",$S$1:$S$3,0)),"")
(07/10/13 Excel version)

 

[Aladin Akyurek]

hI.
I can use this separate function, you could use them together?

=IF(ISERROR(FIND($S$1,J9));$R$1;IF(ISERROR(FIND($S$2,J9));$R$2;IF(ISERROR(FIND($S$3,J9));$R$3;"Not Find)))

Thank you!!!

FIND is case-sensitive. If this is not what you want, switch to SEARCH...

=LOOKUP(9.99999999999999E+307,FIND($S$1:$S$3,J9),$R$1:$R$3)

For a Index/Match approach, see Robert's reply.

 

[marreco]

Hi.

Both form of response helpful, thank you very much!

 

[Robert Mika]

Hi.

Both form of response helpful, thank you very much!

You are welcome.
Thanks for feedback.