Picture and FIle name Matching

How do you want to do the matching? Do you have a column with pictures names, and another column with URLs in the same worksheet? Or do you need to do something fancy like for each file name, try to see if the corresponding URL exists or gives a 404 error?

If you have file names in column A and URLs in column B, the following formula will tell which files don't have URLs, starting in C1 and copy down:

=IF(ISERROR(MATCH("http://photobucket.com/jmautoracing/"&A1,B:B,0)),"MISSING","")

Just noticed that your URLs have 3 t's, I guess that's just a typo but I fixed it in my formula

That's exactly the case covered by my formula.

Your file does not match what you described. Column A just has the part of the filename left of the dot, not the entire filename. See attached for a correction that takes that into account.

After re-reading your description I can't tell if you simply want to identify what's missing, or provide the actual match. Formula has also been updated to show the URL corresponding to the file name on the same line, or MISSING if not found.

Originally Posted by jmautoracing

If you look in colum A. you will see the item name. If you look in the url in column b, you will also see part of the fitem names. I want to match those urls un column b to the correct file name in column A

Did you check my attachment? It hink that will solve it for you.

In Column C, there is an attempt to match the root part of the item name in column A to a URL in column B. If a match is found, the matching URL is displayed; otherwise MISSING is displayed.

The earlier problem was that column A has

abc123

but the URL has

htttp://photobucket.com/jmautoracing/abc123.jpg

which is a little different than your original description.