How to display images dynamically in Excel

This video shows you how to display images dynamically without the need for VBA. You will learn how to use naming cells, ranges and functions. I use the Index and Match function to carry out a lookup task.

Microsoft Tips and Tricks and learning how to be more efficient and effective

[glennclever]

Excellent, your a natural teacher. You explain every detail very clearly. I have set out to learn Excel as best as I can and try to understand every part so I can aly it to what ever I am trying to do. A+++ keep up the great work your posting on here.

[kennethvela]

Perfect, just what I was looking for, thank you so much

[cascodiazcarlose]

I would like to say thank you, it helpe a lot, God bless you.

[BASHIRSAGAGI]

Thank you very much for learning of many knowledge

[Jojosmith]

You're such Super Excel teacher. Definately liked & subscribed. Thank you very much for your valuable lesson. I have tried different ways but yours is the best. Could you please kindly teach us how to look up the photo from a photo from a network shared drive? Thanks a lot

[Barfaki]

Thank you very much. That was really clear and easy to follow

[tomzistatsis]

great tool!, I am trying to use the same index/Match criteria for a second set of images in a different location in my workbook. The problem I have is that the image that is returned shows all the images rather than the one linked to the dropdown selection. Any ideas?

[chixripak]

Interesting video; kinda helps me? I'm looking to have an auction item in each row with an associated picture - up to 300. Then I need to project the image when its time. Can you walk me through that? Or maybe powerpoint would be a better tool?? Thx

[sewingmachinesindetail]

Thank you for this tutorial. Is there any way, that you can reduce the size of the pictures in the cells without reducing the picture quality, so you are able to size up the picture again with good quality?

[jessedunn]

Beware of using this in a workbook with VBA "for" and "with" loops. It seems to slow code execution down by a factor of 11 (eleven)! Remove the linked picture object and you're back to normal speed again. You can verify by re-building the picture object and re-running. Things go back to slow as molasses and almost crashing during execution. I can't figure out exactly whats going on here, but I'd guess a bug. Took months to figure out why macros were running so slow!

[tahajasden]

I did the same, but when i clicked image and typed show image, i got an error that reference is not valid.. Please some one help

[maxvandersandt]

When I want to change the formula which is linked to the picture (=ShowImage in the video) keeps giving me an Error notification. Can someone help me?

[lucienstam]

There is always a grey line around these pictures. In many cases you don't want that. How to get rid of them?

[ryanbriggs]

In case it helps anyone else, the image didn't change for me until I copied and pasted the image again, AFTER creating the link. So I followed all the steps and the image didn't change. I copied and pasted the image, and the new copy of it would change with the dropdown, even while the original one still wouldn't.

[sammysme]

Gone through the whole video but when I click on the image it won't let me write on the formula bar.

[yohannesmekonnen]

just use cell refence. That will make it way easier to follow

[nurmohammed]

this tricks very complicated please make it more easy process. thanks this type of tricks.

[roeyni]

I hink this is not dynamic. Dynamic is to actively load a picture into a cell from a file when you DONT have the images previously inserted into excel. This method will only work for a very limited number of images.