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.