Is it possible to have a cell that will link to one of two hyperlinks? I dont want to use an If function because I have no way of determining which hyperlink will work.

Ideally, you would click the cell, and it would send you to link A (C:\....\filename.xls) and if that link didnt exist it would send you to link B (C:\....\filename.doc) etc.

This is to avoid the problem of not knowing what the file extensions are. The filenames are input by the user. I have tried many other approaches to this problem and nothing seems to be working.

Thanks