Forum Discussion

cleach86's avatar
cleach86
Copper Contributor
May 01, 2023

Hyperlink to open multiple files simultaneously (in a folder)

Hi, 

I am using a reference cell as my look-up value and VLOOKUP nested in a HYPERLINK function, so I will only be able to link to the first option it finds from the top.

 

In the list that I have generated from the contents of a folder using power query there are multiple results, for example: 12345678-0(1), 12345678-0(2), and 12345678-2. 

 

Is it possible to create a link that opens multiple files simultaneously?

Is there a possibility to combine the hyperlink function with one of the dynamic array functions?

 

Any suggestion to solve or even a solution creating awareness that the first of 3 drawings is being linked to would be a big help!.

 

Thanks, Chris

No RepliesBe the first to reply

Resources