Check URL in Worksheet if Active

[ryanb4614]

1) I have a huge directory of images. They are all placed in subcategories on my server. I have a direct URL for each image in a worksheet (each url in its own cell) for every product, but some of the urls do not work or the image is just not there anymore.
2. I have a a worksheet from my distributor but it doesn't tell me what images are in the folders they have provided me. There is 20,000+ products. I do not have time to sort what url is good and has an image and which on doesn't

Is there a way I can have excel tell me what url is good and which on is not? Example. In Column A I have the list urls for the images. Some may not be working. If they are working in column B put a 1 or a letter if they are NOT working put a 0 or a letter? Sort of have excel check the url and if there is an image there it will show a 1? Sort of checking if the url is active or dead