Forum Discussion
Import Hyperlinked Text into a Data Validation Drop Down Menu
I am interested in creating a Data Validation drop down menu that contains report names (text) with an embedded hyperlink. The way I'm doing this now is creating a table on another sheet, listing ...
Hi Adam,
If not embed the links under the report names the HYPERLINK could be an option. You may not embed links under your report names, but have two columns (one with names and another one with links).
With drop-down list you select Report name (not the link on it), and in another cell combine the link on it using HYPERLINK and INDEX/MATCH to find the link for it using Report name.