I'm using the HYPERLINK function and finding it reliably useful. I'd value being able to assign hyperlinks (somehow) to individual menu drop downs.
Let me assume that you are talking about a drop-down via
As you cannot have both formula and value in the same Excel cell, you need to have another cell to build the hyperlink.
Let suppose you have your drop-down menu on column A.