Snakeye wrote:
I'm a bit confused with your functions example. Is there a web location with
more detail or examples on doing this?

Not that I know of; you are the first person to have requested a solution to
this problem with regard to hyperlinks.

If you need the formula explaining:

OFFSET(MyTable,0,0,,1) is the first column of MyTable
MATCH(A2,OFFSET(MyTable,0,0,,1),0) is the index (from 1) within that column of
the row containing the value which is in cell A2.
OFFSET(MyTable,MATCH(A2,OFFSET(MyTable,0,0,,1),0)-1,3,1,1) is the cell in
column 3 of MyTable in the row which has in its first column the value which is
in cell A2. This is the destination of the hyperlink.

If you want to understand the individual Excel functions better, I suggest you
try Excel's help.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup