jump to linked cell

I have made a *** with links to a value in a row of a named range on another *** in the same workbook
I do this with a vlookup formula combined with a value coming from a dropdown in the first ***
=VLOOKUP($B$1;vacancies;21)
it's easy, user friendly and much better than how people worked before

users can and have to change values in the table by hand
now because of the ever growing table in the second *** it is getting more difficult to find the right row
so I was thinking of jumping to the correct cell by double clicking on the linked cell in the 1st ***

I already found the right event for this (I hope):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

but I don't know how to jump to the linked cell of the 2nd ***

can anyone give me hint?

thnx


.