Hyperlink to looked up value

[SueBKor]

This should be incredibly simple, but I've spent way too much time googling and can't find the answer. (And now I'm struggling to explain.)

I have a workbook with a number of sheets. The first column of each sheet is always the employee ID.

The first sheet of the workbook (Lookup) has a validation list of staff names. When a staff name is selected, the rows below pull the data for that staff member from each of the sheets. e.g.

	Column A	B	C
Row 1	Staff name	Joe Smith	Click to Update
2	ID	2
3	Sheet1		Hyperlink(Sheet1, Column A, Row "B2")
4	Role	Test consultant
5	Start Date	1/1/2020
6	Sheet2		Hyperlink(Sheet2, Column A, Row "B2")
7	Qual	Bachelor
8	Discipline	Science

I would like to create a hyperlink, that goes the referenced sheet, and the row for the referenced staff member. The logic I need is "Go to [named sheet]. In column A, look up the value in Lookup!Cell B2, and go to that row."

Using Match, I can look up the row that Staff ID is on for each sheet, but I can't work out how to put that into a hyperlink.

 

[SueBKor]

I worked it out. Finally.
I realised that NO hyperlink functions were working at all. It wasn't necessarily that my formula was broken. That changed what I was Googling answers for!
The key was to put a "#"at the front of my address.
=HYPERLINK("#"&D5&"!"&E5&F5,"Click to update this information")
D5 = sheet name
E5 = column letter
F5 = match formula giving me the row number for the specific Staff ID.