Very interesting question.

This formula worked for me.:-

Formula: copy to clipboard
=HYPERLINK("#Sheet1!G"&MATCH(C1,F1:F50,0),"Try Here")