You ready for some work?

I would insert a new worksheet (later hide this sheet).
In column A would be the tool part number.
In column B would be the location that I need to jump to.
And create range names for each of these locations--the name of that range would
go in column B.

Debra Dalgleish has tips on naming ranges:
http://www.contextures.com/xlNames01.html

So for instance the table would look like:

Part# Jump to
12345 Cate001
12346 Cate002
12347 Cate001 (I figured multiple part numbers would jump to the same spot)
....

Then name the data in column A so that it can be used in a Data|Validation cell
in the original worksheet (say A1).

Then put this formula in B1.
=if(a1="","",HYPERLINK("#"&VLOOKUP(A1,hiddensheet! a:b,2,FALSE),"click me"))



Brisebear wrote:

I have a spreadsheet with a significant number of tool details on a
number of sheets (broken down by market type). I have a front page
that summarises the other sheets, but what I want to add to the front
page is a search function that then enables a hyperlink function to
take the user to the location in the spreadsheet where that tool
number's details are located.
I can use the VLOOKUP function to search for the tool number and verify
it's existance, but I dont know how to use the functions or write a
macro or VBA to hyperlink to that tool number. Any suggestions?
Brisebear.

--
Brisebear
------------------------------------------------------------------------
Brisebear's Profile: http://www.excelforum.com/member.php...o&userid=37689
View this thread: http://www.excelforum.com/showthread...hreadid=572958

--

Dave Peterson