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
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

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

    Default

    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

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
  •