hyperlink to first match

quick bit of help if you don't mind

this is my current code

Please Login or Register  to view this content.

and have been looking online on ways to have it hyper link to the location on the other sheet. But i havent the first idea where i would plumb in the addiational bits from this site https://exceljet.net/formula/hyperlink-to-first-match

if you could help that would be great

cheers and thanks

Originally Posted by leelnich

Hi Murray83, I've moved ROW calculation to column G so formulas in columns H:J can share the result. Note that hyperlinks to HIDDEN SHEETS don't work. You'll have to deal with that somehow (VBA?)

Anyway, the Hyperlink Formula looks like this (in H2, copied down):

Please Login or Register  to view this content.

That is bloody great works a charm and thanks if i could i'd hug you

Thanks is all i can say