Using the list of topics and associated hyperlinks below…
…, we want the user to select a topic from a Data Validation drop-down list and have the link displayed below the user’s selection.
Begin by setting up the Data Validation list.
- Select the cell for the drop-down and create a Data Validation list that uses the list of topics found in Column A of our example.
- Select the cell for the returned link and we will use a VLOOKUP function to locate the selected item in the previous step’s drop-down cell. For our example, the formula would look something like the following:
=VLOOKUP(B4, A7:B14, 2, False)
Although this will return the link address associated with the selected topic, the link is not clickable.
To make the returned information clickable, wrap the VLOOKUP function within a HYPERLINK function.
=HYPERLINK(VLOOKUP(B4, A7:B14, 2, False))
We now have a selectable, clickable hyperlink cell.