Connecting Hyperlink to Value Rather than Cell

[Xopowo]

Good afternoon all,

Thanks for your time in reading this and hopefully offering a solution! We have a spreadsheet with multiple tabs all linking back to a single tab with sortable data. Each cell of data needs to be hyperlinked to other tabs, yet when the sorts are applied the hyperlinks stay with the cells and not with the data. After an extensive search, we've used the match and hyperlink functions together like this:

=HYPERLINK("#Sheet1!'Fraction to Decimal'"&MATCH("Fraction to Decimal", Sheet1!A1:ZZ2, 0),"Fraction to Decimal")

This returns an #N/A error, which seems to indicate that no such data is within the specified range of A1:ZZ2. Any ideas? Thoughts? Anything at all would be greatly appreciated as this has stumped us for quite some time.

[NBVC]

Your MATCH() lookup range needs to be 1-dimensional.. i.e. either one row high or one column wide...