Creating a dynamic hyperlink to a different sheet in the same workbook.

Hi All

I have a workbook with two tabs, one named EMP which is a list of all employees, with these names starting in Col E. There is a Line reference number in Col A. (I.e where they can be found on the worksheet). their information goes from Col F to Col BP. (Table format)

In the other tab, named ADV, (essentially a search) a name can be entered in Cell C4, it pulls all the data from the EMP tab and displays it throughout the sheet. In Cell B5 is a formula which references their name against the line number found in the EMP tab Column A). (=VLOOKUP(C4,choose({1,2},EMP!E:E,EMP!A:A),2,0). (I.e if Joe Bloggs was entered in C4, result (Line Ref) 45.

What I'm trying to achieve is a dynamic hyperlink that uses the line reference number in B5 and jumps to that line number in the EMP tab allowing an easier edit or update to information supplied. I would like the formula to be in cell c5.
Some parts of the information is updated very regularly, namely any training which is in the EMP tab, Column X. I would also like to have another dynamic hyperlink that would take me to the training section in the EMP tab, e.g. if Joe Bloggs was the input, the hyperlink link would go to Cell X45.

Can you help?

Something like below, but without a sample, I don't think that you will get much help.

=HYPERLINK("#"&CELL("address",INDEX(B:B,MATCH(F2,A:A,0))),INDEX(B:B,MATCH(F2,A:A,0)))

Hi I've attached a copy of the spread sheet. I've had to delete most of the table out because of the file size. All data entered is made up.

If you look at Cell B5 on the ADV tab, it has correctly referenced the person against Col A of the EMP tab

What I would like therefore in C5 is a hyperlink, which in this case would take me to Cell A4 in the EMP tab

in C5: =HYPERLINK("#"&CELL("address",INDEX(EMP!$A$3:$A$364,MATCH(ADV!$B$5,EMP!$A$3:$A$364,0))),"Jump")

Thank you. Works a treat.

Glad to help. Thanks for rep.