I have very large list of hyperlinks in a column to call up music or video files. Is there formula that will let me know which of the links cannot find the file for whatever reason. I don’t need the reason why, I just want to know which ones do not work. 

I have enclosed an image below to help demonstrate. 

The names of the files are in col. A

The directory in B

The Hyperlinks are in col D. =HYPERLINK(B1,A1)

​I have very large list of hyperlinks in a column to call up music or video files. Is there formula that will let me know which of the links cannot find the file for whatever reason. I don’t need the reason why, I just want to know which ones do not work.  I have enclosed an image below to help demonstrate. The names of the files are in col. AThe directory in BThe Hyperlinks are in col D. =HYPERLINK(B1,A1)   Read More

​