MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlinks and VLOOKUP

Posted by Connie on June 26, 2001 1:08 PM

I have a list of 15 topics in col A. This list of 15 topics has been pared down from a larger list using a RANK+COUNTIF formula (thanks, Aladin!).

Ideally, I'd like for the user to be able to click on any one of these topics and be taken to a single Topic Worksheet where they can read more about that topic.

I've got the topic worksheet in place, and it uses VLOOKUP to fill in the cells with various information about the chosen topic. Note: The Topic Worksheet is *one* worksheet that contains information about whichever topic was chosen. There's not a separate worksheet for every topic. All this works fine provided it is told which topic to look up. This is where I'm stuck. Is there a way to pull in the topic name that the user clicked on from the list of the 15 topics (without using VBA)? If this isn't possible, I suppose I can make a separate worksheet for each topic and then do regular hyperlinks from the List of 15 worksheet.
Any ideas or thoughts appreciated.

Posted by Kevin James on June 26, 2001 3:52 PM


Seeing as hyperlinks allow you to link to any file on the web or your local computer, how about re-thinking your development to have those links go to MS-Word documents, which seems to make more sense given your scenario.