Hi

Bit of a tricky one. I have two sheets, a data sheet and a summary sheet. On the data sheet is name, score, and code
ofn the summary sheet is the name and score and a column where I want a link to be inserted.

example:

sheet 1:
name score code
bLACK 5 1A
RED 4 2A
BLUE 5 3A

SUMMARY
5'S
NAME SCORE LINK
BLACK 5 NSERT LINK TO SHEET 1 ROW BLACK
BLUE 5 iNSERT LINK TO SHEET 1 ROW BLUE

4'S
NAME SCORE LINK
RED 4 NSERT LINK TO SHEET 1 ROW RED

The summary sheet is a few pivot tables filtering by scores. Is there a way to look up the code and insert a hyperlink using VBA or non VBA?

Thanks

I tried this formula but the link didn't work:


=INDIRECT("'sheet1!"&"$B$"&MATCH('SUMMARY 2 (2)'!A9&'SUMMARY 2 (2)'!B9,'sheet1'!$S$1:$S$682,0))&"'!$B$"&MATCH('SUMMARY 2 (2)'!A9&'SUMMARY 2 (2)'!B9,'sheet1'!$S$1:$S$682,0)

Thanks