Lookup and partial match to Filtered visible cells

Ponivista

New Member
Joined
Nov 13, 2018
Messages
1
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)
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".

ABCDEF
Filter List
Bob
Joe
John
Kelly
Mary
Nathan
Shaun
Sue
Thomas
Data ListMatch Any
JohnMarySueTrue/False
SueJoeNathanTrue/False
KellyBobThomasTrue/False
ShaunSisterMaleTrue/False

<tbody>
</tbody>



Thanks in advance.

Regards,

Ponivista:confused:
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,215,232
Messages
6,123,768
Members
449,122
Latest member
sampak88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top