Hi there, I hope you are all safe and well amidst this weird year of 2020. I have a particular issue on Excel I am struggling with.

I have a list of product codes, 21,000 to be exact and i have labelled these as products_array.

I need to check a list of 100,000+ filenames if their filename partially matches the full code in products_array.

For instance, the products_array list has codes like this.

AB123456789
AB123456780

The filenames are something like as follows.

Image_AB123456789_098.jpg
Image_B4329499994_093229.jpg

With the above examples, the first image matches one of the codes, so we would flag that while the second image does not, so we are not interested in that.

In your guys opinions which I value highly, what is the best way of doing this? Logically trying to wrap my head around this is proving to be a bit of a pain.