MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HYPERLINK SEARCH AND REFERENCE


Posted by GABE on May 26, 2001 12:14 PM

Hi,
I was wondering if you could help solve my problem.
In my worksheet I have COL A (ID) and COL J (TOTALS).
How do I hyperlink to another worksheet so that using
the ID #### will return the value in Col J. I can't hyperlink directly
to, say J25, because my table is always fluctuating and
it throws off the hyperlinks.

Thanks
gabe


Posted by Aladin Akyurek on May 26, 2001 12:40 PM

Gabe,

Why not use VLOOKUP instead of a hyperlink?

Aladin