Hypelinks

[rtuck]

Im trying to relate a hyperlink to a value returned earlier within a spreadsheet.

i.e the person selects nokia 3330 and the hyperlink then lists the correct one for a nokia 3330.

I can insert a hyperlink but I am having problems putting it within a formula without that formula becomming a text nightmare.

I want a list of hyperlinks and the cell to pick the correct one based on the entry in another cell.

Thanks

 

[Aladin Akyurek]

I wonder why I keep taking up these hyperlink questions, a rather nasty part in Excel.

I'd suggest that you create 3-column list in some worksheet, consisting of indices or keywords, true URL's (addresses, not hyperlinks themselves) associated with them, and display names that you use to display the link.

An example record in the 3-column list would be:

{"Excel Questions","http://mrexcel.com/board/","MrExcel"}

Lets say that you have an index or a key value for which you want to retieve a URL address, which must become a clickable hyperlink after it's fetched.

You can use

=HYPERLINK(VLOOKUP(A1,URLList,2,0),VLOOKUP(A1,URLList,3,0))

where A1 houses a keyword and URLList is the name that you give to the 3-column list via the Name Box on the Formula Bar.

Aladin