Hyperlink with Criteria

[acerlaptop]

Hi guys.

Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell.

=HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")

 

[JustynaMK]

Assuming that the value of 2020 is stored in cell D21 you can try the following formula:

=HYPERLINK("#"&ADDRESS(MATCH(A4,INDIRECT("'"&D21&"'!A:A"),0),8,1,1,D21),"Link")