Posted by Paul Vordtriede on September 19, 2001 8:07 PM
Is there a way to use some type of search (VLOOKUP, ADDRESS/MATCH, etc.) to search a column of numbers on a another sheet (within the same workbook) for a specific value and return the cell address as a hyperlink?
We're using a workbook to hold information about 20,000 different samples spread across about 20 different worksheets in this workbook. We would like to create a few index pages that allows us to move down the data in a rational way.
We've designed the index pages but don't want to have to put in 20,000 hyperlinks manually. Any suggestions?