Search and "mark" sheet with 35k rows of data against 1k names for partial match?

[xdriver]

I have a sheet with about 35k rows and 100 columns containing names of contacts along with different kinds of data. Each row has up to 4 cells which include a combined first and last name in a single cell (john doe) (mary jane) etc.

I have another list of about 1k names, such as (doe) or (jane) and I would like to mark the row of the list with 35k names if one of the names from the 1k list is a partial match. None of the 1k list is (john doe), but is simply (doe). The name can appear in any of the 4 cells. I don't mind adding a column, or even extracting all the matching rows into another sheet to create a new database of names and data.

What would the most efficient way of doing this be?

I came across this posting, but I am unsure if this would work with some kind of modification or even be efficient with such a large sheet of data. How to filter a table with two email columns against a list of emails

Thank you

 

[xdriver]

Note, the match from the 1k list must be exact but it may be partial, for instance, it must match the 35k list with either "john" or "doe" but not "joh".

I have figured out using xlookup to make this work in a single column out of the 4 columns in the larger list, but it is returning partials such as "joh" or "ohn" and I do not want that.

 

[xdriver]

This is what I was trying to use =XLOOKUP(TRUE,ISNUMBER(SEARCH('Name Lists'!$A$3:$A$1012,Data!H2)),'Name Lists'!$B$3:$B$1012)

I would prefer it returned the name instead of the number related to the name in the Name List, or simply "true"

2023_11_17 - testing.xlsx
	H	I
1	Owner 1	Owner 2
2	Frederick H Smith	Lisa G Char-Smith
3	Jeffrey A Daniels	Carrie Martin
4	Scott A Joseph	Shelley M Joseph
5	Rivka Kandinov	Boris Kandinov
6	Frank&s Magullion Ret	Frank Magullion Tr
7	Michael Escovitz	Pinky Patel
8	Angelo L Petulla	Takako Petulla
9	Muhammad H Usmani	Tuba S Abbasi
10	Guichen Z Wong	Sanford Wong
Data

2023_11_17 - testing.xlsx
	A	B
1	Names	Cell
2	Smith	2
3	Nushi	3
4	Wei	4
5	Yan	5
Name Lists