using INDEX/MATCH as within_text in SEARCH function through ISNUMBER

[MOHsab]

Hi anyone,
I have a serious question, about using INDEX/MATCH as within_text in SEARCH function through ISNUMBER.
I want to use INDEX/MATCH to find a proper string through a cell range and check that, if it has my text in itself, so I wrote below formula, but it doesn't work and I don't know why! please help me to solve it.

ISNUMBER(SEARCH(A2,INDEX(range1,MATCH(1,INDEX(B2=range2)*(C2=range3),0,1),0))))

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.