David,
Nice one - you guessed right.
Tony
-----Original Message-----
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?
.