Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 262
- Office Version
- 365
- Platform
- Windows
Hi Folks - Thanks for taking a look at this.
I have a few ranges of data:
There are many more ranges, Range 1 thru Range 20. As per the above, Range 1 and 2 and so on, have a listing of data entries e.g. Range 1 has Keary, Murphy, Kelly, Malluisk, Kernan and littleton - names will be added and removed from time to time.
The listing column needs to be able to determine if any word in it's listing, appears in any of the cells across all the ranges.
The logic for Cell F3 needs to check of any of the entries in Range 1 are in Cell E3, or, in Range 2 are in E3 and tag it accordingly. There can be anything up to 20 ranges.
Any help appreciated - Thanks - Mark.
I have a few ranges of data:
There are many more ranges, Range 1 thru Range 20. As per the above, Range 1 and 2 and so on, have a listing of data entries e.g. Range 1 has Keary, Murphy, Kelly, Malluisk, Kernan and littleton - names will be added and removed from time to time.
The listing column needs to be able to determine if any word in it's listing, appears in any of the cells across all the ranges.
The logic for Cell F3 needs to check of any of the entries in Range 1 are in Cell E3, or, in Range 2 are in E3 and tag it accordingly. There can be anything up to 20 ranges.
Any help appreciated - Thanks - Mark.