Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Hypelinks

  1. #1
    New Member
    Join Date
    Feb 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    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.


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    The Hague, NL
    Post Thanks / Like
    37 Post(s)
    7 Thread(s)


    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","","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


    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.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts