Linking to Cell in Different Worksheet

[purceld2]

Hi
I haven't used Excel for years and forgotten how to link to another cell.
Basically I have two sheets in the same workbook and I am able to use MATCH to find the cell I want to navigate to in the other sheet.
What I now want to do is to hyperlink to the cell in the other sheet.

Can somebody point me in the right direction please.

Kind Regards

Desmond

 

[eduzs]

Try:

=HYPERLINK("[WorkBookName]WorkSheetName!CellReference","TextToShow")

 

[purceld2]

Try:

=HYPERLINK("[WorkBookName]WorkSheetName!CellReference","TextToShow")

Thanks Eduzs for your response

Unfortunately I am still having trouble getting the formula to work.

I am entering

=HYPERLINK("[WhatsApp Consolidated Data 30012021]Music Library 10022021!Q2","TextToShow")

Q2 holds the Value "A25838" which is the cell in "Music Library 1002202" which I want to Hyperlink to

Also if both Sheets are in the same workbook do you need the Workbook name?

Regards

 

[eduzs]

Try:

=HYPERLINK("[WhatsApp Consolidated Data 30012021.xlsx]'Music Library 10022021'!"&'Music Library 10022021'!Q2,"TextToShow")