In D6 on Calculation sheet: =HYPERLINK("#INDEX(IRM!A:B,(MATCH(calculation!B6,IRM!A:A,0)),2)",INDEX(IRM!A:B,(MATCH(calculation!B6,IRM!A:A,0)),2))
Edit.
btw, in post #2 here you've second link where (after jump there) in post #4 - a little explanation how to do it and example xlsx file also.
result of above formula is: explanationtest5!A1 so if you want jump to this address (explanationtest5!A1) simply add "#"& in front of index:
=HYPERLINK("#"&INDEX(IRM!$A$2:$B$7,MATCH(calculation!B6,IRM!$A$2:$A$7,0),2))
but if the source will not be an address (e.g. blah blah blah) you will get error. That means result of formula (INDEX..etc.) should return address.
general:
you need decide what formula return: text or address
If formula return text, use:If formula return address, use:
in these cases you can drag down both, but you cannot use one kind of formula with mixed results. (Sometimes you can, but it depends where you want to jump with hyperlink)
Bookmarks