How to create hyperlinks that link to files in dif

问题:

I have a column in excel with the names of different invoices on my computer and I need to create a hyperlink for each invoice name. I tried to press CTRL+K and manually create a hyperlink for each invoice at the beginning, but that was just too much work because I have hundreds of invoices.

Right now, I am using this formula:

=HYPERLINK("C:\Users\Jimmy\Documents\Excel Formula Testing\2015\January" & B2 & ".xlsx", B2)

and it is working fine. However, not every invoice is in this folder so, I need a formula that looks up the file from the external folder.

        

回答1:

Try this formula. This should work for you creating dynamic hyperlinks for each month and year.

=HYPERLINK("C:\Users\Jimmy\Documents\Excel Formula Testing\"& TEXT(A2,"yyyy") &"\" & TEXT(A2,"mmmm") & B2 & ".xlsx", B2)