Hyperlink to a cell in another sheet, but the cell is determined dynamically

[amoebasinger1]

Hello,
Using Address and Match functions, I can find the address of a cell in another sheet that contains given text. It might look like this, for example:
=ADDRESS(MATCH(“Bachman-Turner Overdrive//II”, ‘file:///C:/~My Documents/Music Collection 10.ods’#$LP.D3:D5000),1)

But can I generate a hyperlink that will navigate to the other spreadsheet and make that cell active?

Thanks in advance.

J

[ady]

Use the HYPERLINK() function, for instance: =HYPERLINK(ADDRESS(MATCH("Bachman-Turner Overdrive//II", 'file:///C:/~My Documents/Music Collection 10.ods'#$LP.D3:D5000),1))