Hi,
I have a problem i need help solving..
I have two columns of data on the same spreadsheet, which look like this:
A B
19300617317231.jpg 19300617317231
19300617342332.jpg 51465416516566
19300617421297.jpg 304514010502
19306617342363.jpg 432165651882
1940055020068.jpg 7889195151615
1940055020068a.jpg 9306617342363
304514010502.jpg 648132121333
3045140105106.jpg 4784165161221
4025700001023.jpg 7871516513213
I need a formula which looks up the last 11 Digits in column B and Checks that there is a match in column A which will then return the string of numbers into a new column (c)
To show that it exists in both columns.
Note: it is expected that not all of column A will have a valid return!
Attached is sample of my data as this is my first time posting and i know im not being very Clear!
In the attachment there should be 4 valid entry's that are the same.
Thanks!
Bookmarks