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

• Edited by ahmadissa162 Tuesday, June 09, 2015 7:12 PM

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. Im glad to help and follow up your reply.

Regards,

George Zhao
TechNet Community Support