Dropdown list returning an image based on selection

Question

Hi all,&nbsp;Hopefully someone has a solution. I have created a list of people that when selected brings up some personal information but would also like it to return a headshot of the individual. Any suggestions or support on how I can achieve this would be great.&nbsp;Thanks.

patrick2788 · Answer

If you have 365, you could use the IMAGE function.
https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5?ns=excel&version=90&ui=en-us&rs=en-us&ad=us

trc10 · Answer

Patrick2788&nbsp;thanks for the response, how would this work if the images are not web based? i.e. in a folder on the desktop?

hansvogelaar · Answer

TRC10&nbsp;
See this recent discussion: Insert a conditional image into a cell&nbsp;

patrick2788 · Answer

TRC10&nbsp;Eventually, it's going to be as easy as this:&nbsp;The above is a screen capture from Excel 365 running an Insider's build where you can insert a picture directly into a cell.&nbsp; For your task, it'd simply be a matter of inserting the pictures in a sheet - each picture in an individual cell and then referring to the cells with pictures where needed.

peiyezhu · Answer

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-use-the-image-function-with-local-images/e539c52e-fe3c-40d0-b0da-fcbcc16802b2
Run a web host on your PC to convert local images to urls.

https://github.com/FiloSottile/mkcert
making locally-trusted development certificates

or
https://support.microsoft.com/en-us/office/block-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795#:~:text=Dynamic%20Data%20Exchange%20%28DDE%29%20is%20an%20older%20Microsoft,want%20under%20Security%20settings%20for%20Dynamic%20Data%20Exchange%3A
allow extrenal links

Forum Discussion

Dropdown list returning an image based on selection

Share

Resources