Automatic solution for hyperlink within the same file

[Newbie73]

Hi everyone, I'm dealing with huge amounts of date across different sheets in the same file. On sheet1 let's say I have a full list of values (some of them duplicated) in the same column and on Sheet2 I have a list of some (not all) of those values as unique values. Manually, I can create a hyperlink say on Sheet2 A2 and manually add a reference on Sheet1 where the same value is (let's say H777). Clicking now on Sheet2 A2 Value will take me to the same value on Sheet1 H777.

Is there a way to automatically do this on a column? Automatically look for where the exact value is on Sheet1 column and create an hyperlink to that location?

Test example:

test3.xlsx

1drv.ms

Thanks in advance

 

[etaf]

you are welcome