Forum Discussion
cleach86
May 01, 2023Copper Contributor
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