Hello.
Please refer the attachment.
The Data List is in column A with multiple words in a single string in each cell A14:A17
Column A (starting at A13)
<tbody>
</tbody>
The Filter list of unique words are in F1:F10 (table name:"tblList and contains the following in a "table" that can be filtered:
<tbody>
</tbody>
I want to select various filters in "tblList", some to be on and others to be off to then return a corresponding True/False to appear in column B13:B17 if the same row in column A has any partial match to any values in "tblList" are visible.
example:
True is returned at cell B13 if there is a partial match to any part of the string in A13, when the tblList is on (visible) for: "Mary", Sue" and /or "John".
<tbody>
</tbody>
Thanks in advance.
Regards,
Ponivista
Please refer the attachment.
The Data List is in column A with multiple words in a single string in each cell A14:A17
Column A (starting at A13)
Data List |
JohnMarySue |
SueJoeNathan |
KellyBobThomas |
ShaunSisterMale |
<tbody>
</tbody>
The Filter list of unique words are in F1:F10 (table name:"tblList and contains the following in a "table" that can be filtered:
Bob |
Joe |
John |
Kelly |
Mary |
Nathan |
Shaun |
Sue |
Thomas |
<tbody>
</tbody>
I want to select various filters in "tblList", some to be on and others to be off to then return a corresponding True/False to appear in column B13:B17 if the same row in column A has any partial match to any values in "tblList" are visible.
example:
True is returned at cell B13 if there is a partial match to any part of the string in A13, when the tblList is on (visible) for: "Mary", Sue" and /or "John".
A | B | C | D | E | F |
Filter List | |||||
Bob | |||||
Joe | |||||
John | |||||
Kelly | |||||
Mary | |||||
Nathan | |||||
Shaun | |||||
Sue | |||||
Thomas | |||||
Data List | Match Any | ||||
JohnMarySue | True/False | ||||
SueJoeNathan | True/False | ||||
KellyBobThomas | True/False | ||||
ShaunSisterMale | True/False |
<tbody>
</tbody>
Thanks in advance.
Regards,
Ponivista