Dropdown list returning an image based on selection

[TRC10]

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 suggestions or support on how I can achieve this would be great.

Thanks.

[#2]

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=ex...

[#3]

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

[#4]

@TRC10 

See this recent discussion: Insert a conditional image into a cell 

[#5]

@TRC10 

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.

[#6]

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-use-the-image-function-with-local-im...
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-102...
allow extrenal links