How to make link location in hyperlink formula, dynamic

[dinesh shah]

In Sheet1, Cell K1 I have the following formula

=Hyperlink ("#'MasterData'!A1087", "Link")

In this formula I have entered link location A1087 manually.

A1087 is in cell J1 of the same sheet 1 and is dynamic.

What i want is, when cell value in J1 becomes A1088 it should automatically appear in the formula in K1 in place of A1087 (i.e.link_location) without using VBA code

Is it possible? Can you help me with this?

Thanks in advance for your help.

Best regards,

 

[FormR]

A1087 is in cell J1 of the same sheet 1

If J1 literally contains "A1087" - then you could try.

=HYPERLINK("#'MasterData'!"&J1,"Link")

 

[dinesh shah]

If J1 literally contains "A1087" - then you could try.

=HYPERLINK("#'MasterData'!"&J1,"Link")

Thank you so much. It worked.