How do I find out if the last 4 numbers in C 1 apprear in all of C 2?

[dme613]

How do I find out if the last 4 numbers in cell A1 appear in the whole range of C2?

<table border="0" cellpadding="0" cellspacing="0" width="307"><col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="mso-width-source:userset;mso-width-alt:5595;width:115pt" width="153"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:116pt" height="20" width="154">C1</td> <td style="width:115pt" width="153">C2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0001_DSC_8504.jpg
</td> <td>0003_DSC_8506.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0002_DSC_8505.jpg</td> <td>0005_DSC_8508.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0003_DSC_8506.jpg</td> <td>0007_DSC_8510.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0005_DSC_8508.jpg</td> <td>0016_GV8F2571.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0006_DSC_8509.jpg</td> <td>0018_GV8F2576.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0007_DSC_8510.jpg</td> <td>0023_GV8F2581.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0011_GV8F2564.jpg</td> <td>0024_GV8F2582.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0012_GV8F2565.jpg</td> <td>0026_GV8F2584.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0013_GV8F2566.jpg</td> <td>0031_GV8F2596.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0014_GV8F2567.jpg</td> <td>0035_GV8F2600.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0016_GV8F2571.jpg</td> <td>0038_GV8F2603.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0018_GV8F2576.jpg</td> <td>0039_IMG_0004.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0019_GV8F2577.jpg</td> <td>0046_GV8F2608.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0020_GV8F2578.jpg</td> <td>0047_GV8F2609.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0021_GV8F2579.jpg</td> <td>0077_GV8F2638.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0022_GV8F2580.jpg</td> <td>0078_GV8F2639.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0023_GV8F2581.jpg</td> <td>0083_GV8F2644.jpg</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">0024_GV8F2582.jpg</td> <td>0084_GV8F2645.jpg</td> </tr> </tbody></table>

 

[Cindy Ellis]

Hello, and welcome to the board!
I think I can help answer your question, but I'm not 100% clear on what you're asking. I can interpret it a couple of ways:
1. There's a long list of jpg file names all in cell A1 (or C1, depending if I read the title or the text of the question), and a long list of file names in cell C2, and you want to see if the last four file names in C1 are found in C2.
2. There is a list of jpg file names in column A, and another list of file names in column C, one file name in each cell, and you want to find out if the last 4 digits of the file name (before the .jpg) in each cell in column A are found in any cell in column C.
3. Maybe some interpretation I didn't think of?

If I know what you're asking, I can probably help.

Cindy

 

[dme613]

You got it in #2

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this, copied down?

Excel Workbook
	A	B	C
1
2	0001_DSC_8504.jpg		0003_DSC_8506.jpg
3	0002_DSC_8505.jpg		0005_DSC_8508.jpg
4	0003_DSC_8506.jpg	Yes	0007_DSC_8510.jpg
5	0005_DSC_8508.jpg	Yes	0016_GV8F2571.jpg
6	0006_DSC_8509.jpg		0018_GV8F2576.jpg
7	0007_DSC_8510.jpg	Yes	0023_GV8F2581.jpg
8	0011_GV8F2564.jpg		0024_GV8F2582.jpg
9	0012_GV8F2565.jpg		0026_GV8F2584.jpg
10	0013_GV8F2566.jpg		0031_GV8F2596.jpg
11	0014_GV8F2567.jpg		0035_GV8F2600.jpg
12	0016_GV8F2571.jpg	Yes	0038_GV8F2603.jpg
13	0018_GV8F2576.jpg	Yes	0039_IMG_0004.jpg
14	0019_GV8F2577.jpg		0046_GV8F2608.jpg
15	0020_GV8F2578.jpg		0047_GV8F2609.jpg
16	0021_GV8F2579.jpg		0077_GV8F2638.jpg
17	0022_GV8F2580.jpg		0078_GV8F2639.jpg
18	0023_GV8F2581.jpg	Yes	0083_GV8F2644.jpg
19	0024_GV8F2582.jpg	Yes	0084_GV8F2645.jpg
Check List

 

[dme613]

perfect, thanks!