Forum Discussion
Dropdown list returning an image based on selection
Hi all, 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...
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
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
Patrick2788 thanks for the response, how would this work if the images are not web based? i.e. in a folder on the desktop?
- 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 Eventually, it's going to be as easy as this:
The above is a screen capture from Excel 365 running an Insider's build where you can insert a picture directly into a cell. 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.
See this recent discussion: Insert a conditional image into a cell
