how to get hyperlink from one cell in to another cell

[kaan]

I need a formula in coulomb B =IFERROR(HYPERLINK(INDEX(D3:H3,MATCH(c3,D3:H3,0)),C3),"NO REVISION")
which is showing the same hyper link like the result in coulomb C =max(d1:h1) (highest score between D and H)
When I can click on coulomb B on the result , should open the hyper link of coulomb C


with my formula, I can get the result in coulomb B BUT NOT THE HYPER LINK OF COULOMB C
A B C D E F G H
SHOPS "Click to Jump TO THE VALID PRICE LIST " valid price list number price list-1 price list-2 price list-3 price list-4 price list-5
SHOP-1 4 4 1 2 3 4 -

[mehmetcik]

Very interesting question.

This formula worked for me.:-

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

[kaan]

thank you for your help,
I have changed my excel can you please see attached excel why the hyperlink does not work?

thanks in advance