Lookup and partial match to Filtered visible cells

[Ponivista]

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)
[TABLE="width: 100"]
<tbody>[TR]
[TD]Data List[/TD]
[/TR]
[TR]
[TD]JohnMarySue[/TD]
[/TR]
[TR]
[TD]SueJoeNathan[/TD]
[/TR]
[TR]
[TD]KellyBobThomas[/TD]
[/TR]
[TR]
[TD]ShaunSisterMale[/TD]
[/TR]
</tbody>[/TABLE]

The Filter list of unique words are in F1:F10 (table name:"tblList and contains the following in a "table" that can be filtered:

[TABLE="width: 74"]
<tbody>[TR]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]Kelly[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[/TR]
[TR]
[TD]Nathan[/TD]
[/TR]
[TR]
[TD]Shaun[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[/TR]
[TR]
[TD]Thomas[/TD]
[/TR]
</tbody>[/TABLE]

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".

[TABLE="width: 436"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Filter List[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Joe[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kelly[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Mary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nathan[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Shaun[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sue[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Data List[/TD]
[TD]Match Any[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JohnMarySue[/TD]
[TD]True/False[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SueJoeNathan[/TD]
[TD]True/False[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KellyBobThomas[/TD]
[TD]True/False[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ShaunSisterMale[/TD]
[TD]True/False[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Thanks in advance.

Regards,

Ponivista