check cell on presence of text from range

[nielsb]

Hi there,
my question posted before is still unresolved.

I need a simple formula (no VBA) which checks (e.g. by means of TRUE/FALSE) whether it contains any text from a given range. Preferably it should neglect blank cells therein.

Illustration is given in enclosed example. A formula in orange cell shoucl return TRUE as 'train' in yellow range forms part of 'trainstation' (green cell).

Anybody an idea how to do this?

Regards Niels

[nielsb]

this question wasn't solved, I only thought it fits better on the 'formulae forum'.
As I didn't know how to delete, I opted for 'marked as solved'..

[AliGW]

Duplicate closed. Continue in your original thread here: http://www.excelforum.com/showthread...t=#post4550287