Forum Discussion
Image file as value
I've seen some tutorials that have images embedded in the sheets somehow so that if a value in a cell (A1) is 'orange' for example, a picture of an orange would show up in A2. If A1 'banana', a banana, etc.
It seems to me that if that can be done there should be a way to do what I'm looking for. Would be useful.
https://www.computergaga.com/blog/create-a-picture-lookup-in-excel/
TwifooThat looks very useful and I'm going to bookmark that page. Thank you. It's more complicated than I need though. I just want to drop an image in a cell on the first sheet and have it show up in the corresponding cells on a dozen other sheets.
The image file is provided by clients at infrequent intervals and having to embed each image file into a separate index is too complicated for most of the people who will be using it.
Right now we need to place the image in a cell, copy that cell, and paste it into each of the other sheets manually. I'd just like to streamline that step without having to be the goto person to embed each new image into the worksheet.
I was able to make it work in a limited fashion. I notice though that the image called shows up with a faint borderline around it that the image in the list column does not have. Checking image properties there does not seem to be a way to eliminate this border.
Is this something that must be accepted? The images in the tutorial don't seem to show the border although it's hard to tell as the images run right up to the edge anyway. The images I'm using are client logos and don't always take the shape of a square/rectangle object.