Ok so I have research many options and cant get one to work. What I have is a dropdown menu and based on which value is selected I want a photo displayed.

What I have right now is the main sheet with a dropdown and a 2nd sheet with a table of the dropdown values in one column and the matching file location. I want these in a folder so if someone needs to update a photo they can make a new file with the same name and just copy it into the folder without messing with excel. I have it set up so when the dropdown is selected, below it is a cell that shows the file location (I'll hide this once it works) and I was trying to just have a macro or vb code to use that to display the photo.

I had it set up prior to work with photos on that 2nd sheet but trying to convert. I attached a demo below. Thanks for any help

Photo Demo.xlsm