(another) Custom function to search text string for values occuring within it
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 |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com