I am looking for a custom function to undertake a lookup-type action.

I have a worksheet, where a number of "roles" are listed in cells
D1:X1, a range which I have named as "role_range". I have a list of
values on the left hand side in cells A2:A101, a range which I have
named "d_range". These form the basis of a table, which will be
populated with Yes and No values.

Each "role" has a number of equations, and these are set out on
another worksheet in a range which I have called "eqn_map". Within
this range, column 1 contains the "role" and column 7 contains the
text string that I want searched for instances of values in the
"d_range" list. Each role has a number of equations (i.e. rows) in
"eqn_map". I want the table to return a "Yes" value if any 1 of
the equations for a particular role contains at least 1 instance of a
value contained in d_range, and "No" otherwise.

Many thanks for any advice. I have recently posted a similar (but
different!) query on custom functions for searching within a text
string, but as it was last week I can't seem to find it now for some
reason.

Mike