CoogansBluff
Board Regular
- Joined
- Mar 7, 2021
- Messages
- 55
- Office Version
- 2013
- Platform
- Windows
I’m attempting to have images show up when a certain value appears in a certain cell.
So, on one sheet, I have a column of head shots of people, and in an adjacent column I have a list of their names. (If it’s a photo of Jimmy Stewart, then the name Jimmy Stewart is in the cell beside it.)
I then take a random photo, copy it, and use Name Manager, defining it this way:
=INDEX(Pictures!$C$3:$C$50,MATCH(Master!$BS$10,Pictures!$B$3:$B$50,0))
This linked photo then should change depending on the value in a particular cell. So it changes from an image of Jimmy Stewart to John Wayne to Katherine Hepburn depending on another cell.
I’ve watched multiple online videos, and this process works great – but I can never replicate it.
One of the videos had an example that could be downloaded, and I downloaded it, moved it into my workbook, and it worked fine. I actually converted what he had (photos of flags w/ countries) to what I’m doing (photos with names), and it works perfectly.
However, I need to have 20 linked photos working instead of just one so that I have 20 photos changing based on 20 cell values.
Whenever I try to make the linked photo work, I get ‘Reference is not valid.’
So, on one sheet, I have a column of head shots of people, and in an adjacent column I have a list of their names. (If it’s a photo of Jimmy Stewart, then the name Jimmy Stewart is in the cell beside it.)
I then take a random photo, copy it, and use Name Manager, defining it this way:
=INDEX(Pictures!$C$3:$C$50,MATCH(Master!$BS$10,Pictures!$B$3:$B$50,0))
This linked photo then should change depending on the value in a particular cell. So it changes from an image of Jimmy Stewart to John Wayne to Katherine Hepburn depending on another cell.
I’ve watched multiple online videos, and this process works great – but I can never replicate it.
One of the videos had an example that could be downloaded, and I downloaded it, moved it into my workbook, and it worked fine. I actually converted what he had (photos of flags w/ countries) to what I’m doing (photos with names), and it works perfectly.
However, I need to have 20 linked photos working instead of just one so that I have 20 photos changing based on 20 cell values.
Whenever I try to make the linked photo work, I get ‘Reference is not valid.’