Lookup Pictures in Excel based on a Cell Value

[andreasgruber]

Finally I got it.
After watching several other instructions and failing, you managed to point out the crucial issues.
Thanks, well done again.

[vincenthumeau]

Very Smart Way to change picture. Note that segment can be used directly on the table, avoiding such a way the pivot.
Thanks V2P

[TheGatatsu]

Your solutions and techniques have helped me out alot, especially at work. thank you

[j-mo]

Tips. 1. Pay attention to the formulas, they are adding brackets and commas by typing them manually in places 2. If you are getting problems with =profile_dv stating reference isn't valid go back and check your brackets and commas OR check that your cells containing images are named correctly (i.e. that they are all named Image_1, Image_2, etc instead of A1, etc), if there isn't consistency you will get that error. (Thanks for the guide @myonlinetraininghub)

[jocelynsamson]

Hi Mynda.
It's amazing the possibility that excel can do. I always watch your tutorial video.
I will definitely use this one in the future. Thanks for sharing. Good Stuff. 🙂

[swee]

Wow, I love this! Simple, easy, unique, effective! I prefer the slicers method. Thanks Linda 👌👍💯❤

[Trucpq]

That is great. Can we do more simple with new image() function?

[renafariapilat]

Wow!! I'am a passionate cyclist. I can imagine that this presentation was made with excel! Amazing!

[drgothmania]

2:46 You can create a name for column stage (eg, _stage = Table1[Stage]) and then refer to the name in Data Validation (=_stage). The range will be automatically updated since you name a dynamic area.

[dirtydes]

Superb, thank you for taking the time to deliver such a concise presentation.

[TS-yyjb]

Have used this a year ago..always a winner!

[kennyrose]

Thank you i just discover your channel. I hope i can apply it. Just started learning Excel this month.

[mannymtzgomez]

Nice and so Easy!I'd this requirements years ago, but i was never able to do this.Thanks again for sharing your knowledge and in a very friendly way

[augustodemelo]

Thank you for your excellent explanation. Sometimes, I don't know why, it does not work and shows the error message: "Reference Isn't valid."
Why it happens?
How to solve it?

[PaulRoneClarke]

It's so odd that Microsoft haven't added native support for this. I read a question in MS help on their website from 2003 asking for this. Almost 20 years ago. I've seen it asked for countless times and, while your video is one of the best (Along with Leila Gharani's explanation), there are perhaps 30 videos on Youtube explaining the arcane workarounds people need to use to get this done.
That's Ok. I can do it. But by now, after so many people asking for it, for so many years - it really should have its own function in Excel by now.

[samiakaleem]

Hello,
I followed the video, but when I put the named range in place of image it gives me error 'Reference not valid'. Tried doing it again by following the steps you mentioned carefully but still cant get it right. Any suggestions what could be going wrong? I am using Excel 2010

[VincentBlusseau]

Great! I stumbled upon your video while watching bike videos ;-) I will definitely use that for my next roadbike trips, and for sure, in other professional circomstances! Thanks Linda

[wayneedmondson]

This is awesome Mynda! Just found it. Thanks for sharing these two techniques :)) Thumbs up!!

[JWilsonMFantim]

It would be more interesting if we could do it with graphics too but it was amazing
Congratulations

[ExcelWithChris]

Brilliant stuff. Did it ago but the one here much easier. Thanks.