locked
drop down hyperlinks RRS feed

  • Question

  • i

    I want to know if it is possible to have diferent links for every single choise in my drop down list on excel

    for example, i have my drop down list 

    photo1
    photo2
    photo3
    photo4
    photo5
    etc...

    i want for every photo to have different link to a photo that i have in my computer

    how can i do that

    thank you


    Tuesday, June 9, 2015 7:10 PM

Answers

  • Hi ahmadissa,

    First I created different worksheets with each photos in excel, named any cell on this worksheet you want to hyperlink to be exactly what is on the drop down list (As shown in the following figure).

    Then I created a LIST worksheet and used Data Validation to create a drop down list, and I created a Hyperlink cell under the drop down list with this formula: =HYPERLINK("[TEST_list.xlsx]LIST!"&B1,"PHOTO LINK")

    As shown in the following figure, the fill color with YELLOW was a drop down list and “PHOTO LINK” was a hyperlink. When you select the name in list and then click “PHOTO LINK” cell, you can go to the work sheet which correspond the name in list.

    I uploaded the test file on OneDrive, you can download this file from here: http://1drv.ms/1BZH0SZ

    And you can also watch this video to help you.

    https://www.youtube.com/watch?v=3vRkA_7x9t8

    Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    If you need more help, please let me know. I’m glad to help and follow up your reply.

    Regards,

    George Zhao
    TechNet Community Support


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    • Proposed as answer by George123345 Friday, June 19, 2015 8:41 AM
    • Marked as answer by George123345 Thursday, June 25, 2015 2:40 AM
    Thursday, June 11, 2015 2:26 AM