This may sound ridiculously complicated, but here a stab.
Looking for a practical/proficient process to identify matches between data in two sheet columns. For example lets say I have Sheet 1 with columns A and B and 300,000 rows.


Ref# Folder Path

1 C:\Folder 1\Test.png
...
243 C:\Folder 2\Subfolder 1\Testing.jpg
... .....
300000 E:\Folder1\SubFolder2\Test.doc

I have Sheet 2 with 5 columns and 100 rows

SN Type Title Date Name

1-23 A Dogs 1//1/25 Test.doc
....
35-456 A Cats 1/2/24 Test.png
...
100-D-3 B Pigs 1/4/20 Testing.jpg


I need to create a third sheet that gets the data from Sheet 1 Column A where the data in Sheet 2 Column 5 "Name" is "found" in Sheet 1 Column B.
It seems to me (FWIW) that the main question was one of decreasing processing speed??

Using the attachment in #17 can you describe in words and color coding how (I assume) matching between NDS_Sheet and REF_Sheet works to create OVERLAY?

If we come up with an acceptable 'match algorithm' the rest of the process to integrate into the UI could be a homework assignment