Hi Tony,

=HYPERLINK("#'Teams'!" & ADDRESS(MATCH(C3,Teams!$A$1:$A$10000,0),1),C3)

actually I guess you don't need offset, simply add 10 to the row

=HYPERLINK("#'Teams'!" & ADDRESS(MATCH(C3,Teams!$A$1:$A$10000,0)+10,1),C3)

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tony" wrote ...
Yes, I would like to include the offset function in my
hyperlink formula (I didn't know this was possible). I've
had a go at it but can't work it out. What does the full
formula look like now?