Dynamic hyperlink to file in current folder

[Kelvin Stott]

Hello, I am trying to establish a dynamic hyperlink to cell B3 within a named Sheet within a named workbook that is kept in the same folder, but the following doesn't work:

=HYPERLINK("["&INFO("directory")&"FileName.xlsx"&"]"&"SheetName!"&"$B$3")

Any idea how to get this working?

Thanks

 

[pedie]

are you trying to create a hyperlink so that when user clicks on it it redirects them there?

 

[pedie]

works perfect for me
=HYPERLINK("["&INFO("directory")&"a2.xlsx"&"]"&"Sheet1!"&"$B$10")

 

[Kelvin Stott]

No, I actually want to pull the number in B3 from another workbook in the same folder.

 

[pedie]

simple referencing will work in that case. maybe use indirect function