acerlaptop
New Member
- Joined
- Feb 17, 2020
- Messages
- 44
- Office Version
- 2013
- Platform
- Windows
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")
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")