Wow! I actually paused the video to read the date and description of the video to check if it is an April’s fool video. I never knew that you can set a formula for an image and that it behaves this way. Thank you Leila, this was a great video, beautifully done.
I think you are perfect. Highly capable, highly intelligent, creative, elegant and also, to state the obvious, extremely beautiful. Thank you for teaching me so much about Excel.
Your videos really are amongst the best and easiest to understand. Also I used to live in Marbella and visited where you were in the video. Gosh I miss it now...! Be well.
Thank you so much for this amazing video, Leila! Your example gave me an idea for a creative solution for something I've been troubleshooting for weeks! Keep up the amazing work!
Thank you for this. I have just used this to dynamically display "photos" using the excel "camera" function. This means that the drop-down calls up a "photo"-image that also changes dynamically with the underlying data. I have been trying to find a way to do this and just stumbled across your explanation!
Before this moment I was using macro for doing the same thing however now I learnt 2 new functions indirect and using name manager. Great video and very well explained. Good luck.
Working on a dashboard for theatre locations (where each will have an image attached to the other dynamic facts). As always, your videos/tutorials ROCK!!!!
another lovely vid. thnx... a small note for whom may find interesting: while resizing/positioning an image, if you hold ALT key, it sticks to the walls of that cell.
Thank you so much for very clearly demonstrating this function. It works! I used it for a random image picker. Just one problem I keep getting (please kindly reply/comment if you had a similar problem and/or a solution) - the picture "placeholder" I've used kept duplicating itself, and I end up with many pictures pointing to the same named indirect function, lumping on top of each other. I only noticed their existence because they are sometimes not exactly on top of each other (like not very neatly stacked newspaper where you see the layers sticking out from below), and my file quickly got very big after I used a few of these functions. Anyone had a similar problem?
This was so helpful. Thank you so much! All I wanted it for was to have a dynamic spreadsheet while I'm choosing my next motorcycle. Now I click on the name of the bike I'm interested in, and apart from all the stats and pricing, I get a nice pic too.
Thank you Leila, very useful and up to date! In order to avoid a grey frame around your flag, instead of cropping, you may also fill in the original cell in White.
@@marymary-vj3ze You can either crop like Leila did in the video or fill the cells (with the images in them) with white. the gridlines will disappear unless you draw borders.
Leila thank you very much, people asked me about this, today your video helped me to answer them. your video and effort is praiseworthy. Thank You, Mohammad Rashed Khan Principal Instructor New Horizons Dhaka, Bangladesh
@@LeilaGharani I've gone back to this sheet that's been helpful over the years, and have run into an error for "Reference Isn't Valid". I'm not using pivot tables, so I think it has to do with Name Manager. Any tips on debugging?
Wow - 446k subscribers! Good for you! I've subscribed. Your videos cover so much ground (I just found this little nugget even though I subscribed a while ago), are easy to follow and your depth of knowledge is outstanding! Keep up the great work.
Good video! Did you know google sheets has a function =IMAGE(...) can render any image url as an image in a cell, then called back in VLOOKUPs, pivot tables, anything. Super easy approach and you don’t need to align anything. I learned super useful shortcuts like ctrl a and ctrl 1 for images!
Great content as always Leila, thank you so much for taking the time and making this available. Always enjoy your videos and insight with Excel. Thanks.
What an awesome tutorial. You've just saved me a ton of time for my application. I'll be using it for product quotations where it's mandatory for products descriptions have a photo next to them.
Great video Leila. Works well if the country name is single word, gets a bit untidy if the country name is more than a single word like South Africa. I don’t see a work around without the underscore on the range name and data validation.
Fantastic Tip My Excel Guru!! I wish safety and wellness during this hard time of Covid-19. Thank you again for this tip, i am using this in my office dashboard. all my udemy subscription of your courses has been the most useful thing for me. so thanks!!! Take care excel guru...!!!!
Thank you Leila, I was waiting for this video since your last video. This video helped me a lot. Many thanks! Looking forward to your next video. Enjoy your time in Spain, looks absolutely wonderful!
@@jeantaylor63 Hi Yes. I could have cheated and put UK put actually put United Kingdom. When I created the name, it puts an underscore (_) in place of the space. I therefore created another cell that replaces the space in United Kingdom with an underscore (Substitute Function) and use that as the reference for the "Flag" Name. I hope that makes sense.
Is there perhaps a way of changing the image not from a dropdown but on the active cell, so as you move through cells the image updates to a corresponding image relating to that cell
Hi Leila, I hope you are well. This is a great video that I have followed to the letter, but unfortunately my end result is #REF. I am using Excel 365, does your solution only work on 2019? My worksheet fails at the =Flag stage and gives me a "Reference isn't valid" error. Is there a simple step that is commonly missed by other people that I may have missed also? I hope you can point me in the right direction. ***EDIT*** Figured it out - my names in my drop down list data have more than one word, when I named the cells containing the pictures excel replaced the spaces between the words with an "_" . As soon as I changed the names in my drop down list data to be exactly the same (ie with the "_" instead of a space) it worked perfectly. Thanks for a great video :)
Thanks for your help. The pictures came over to the new document as you described, however when I made the new document into a PDF / print fille the pictures were not visible. Can you help?
Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-pictures-file
This solution is AMAZING, many options in other videos were pretty complicated, but this is great, thanks so much!
Glad you liked it, Emilia!
This is the first time I have seen image linking through name manager. Thank you for teaching us so clearly!
You're very welcome, Glen!
Thankyou. I've been struggle with this topic as I don't have Excel 365. No other youtube tutorial helped me but yours.
Wow! I actually paused the video to read the date and description of the video to check if it is an April’s fool video. I never knew that you can set a formula for an image and that it behaves this way.
Thank you Leila, this was a great video, beautifully done.
:) No April fools here :)
Leila I can’t get enough works to express my gratitude for the knowledge and help I get from your videos, Thanks so much !!!!!
I'm really happy to hear that Frank! Thank you so much for your kind comment & support.
I think you are perfect. Highly capable, highly intelligent, creative, elegant and also, to state the obvious, extremely beautiful. Thank you for teaching me so much about Excel.
You're very welcome. Thank you very much for the kind words Simon!
Your video is the only reason I want to turn the notice from RUclips on, it helps me a lot !
Great job. I appreciate. You are a natural born teacher. I owe you.
Your videos really are amongst the best and easiest to understand. Also I used to live in Marbella and visited where you were in the video. Gosh I miss it now...! Be well.
Great Job... I love the way you explain
Thank you so much for this amazing video, Leila! Your example gave me an idea for a creative solution for something I've been troubleshooting for weeks! Keep up the amazing work!
Thank you for this. I have just used this to dynamically display "photos" using the excel "camera" function. This means that the drop-down calls up a "photo"-image that also changes dynamically with the underlying data. I have been trying to find a way to do this and just stumbled across your explanation!
I love you Leila!!! I've been trying to link images for a week. Finally I could, tks to you!
Before this moment I was using macro for doing the same thing however now I learnt 2 new functions indirect and using name manager. Great video and very well explained. Good luck.
I'm glad you like the video!
You are easily my favourite Excel guru 👍
So nice of you
There’s always something to learn on your channel, I’m happy I found this channel. Well done Leila 👏🏽 👏🏽 👏🏽
Awesome! Thank you!
i've been looking for these steps for so long,,,, really thanks a lot to you... this is an amazing thing to learn in excel... more power to you..
You are most welcome
That's amazing Leila. I never would have thought that it was possible to lookup picture
I'm glad you like it Vida :) Excel is full of surprises!
Working on a dashboard for theatre locations (where each will have an image attached to the other dynamic facts). As always, your videos/tutorials ROCK!!!!
Cool, thanks Stacey!
another lovely vid. thnx...
a small note for whom may find interesting:
while resizing/positioning an image, if you hold ALT key, it sticks to the walls of that cell.
That's a great tip. Thank you!
Your hair looks so perfect when it's in a Ponytail! :) Great tips btw!!
never get tired of learning more excel. subscribed!
Thank you so much for sharing this tricks. This definitely Will save so much time for me to do my jobs.
Very nice thanks! I did not know that! The beauty of Excel is that even after 26 years, I keep on learning things.. and I feel I am not done yet :-)
So true!
Again come up with new excel trick . Your excel skills are simply awesome and it is helping me a lot in my work.
Thank you! There is still so much more I have to learn - that makes it fun though :)
Thanks for this! I know it was four years ago but I’m basically on step one. This is so cool and easy to follow. I appreciate the thoroughness ❤️❤️
Awesome! Thank you!
Thank you so much for very clearly demonstrating this function. It works! I used it for a random image picker.
Just one problem I keep getting (please kindly reply/comment if you had a similar problem and/or a solution) - the picture "placeholder" I've used kept duplicating itself, and I end up with many pictures pointing to the same named indirect function, lumping on top of each other. I only noticed their existence because they are sometimes not exactly on top of each other (like not very neatly stacked newspaper where you see the layers sticking out from below), and my file quickly got very big after I used a few of these functions. Anyone had a similar problem?
This was so helpful. Thank you so much! All I wanted it for was to have a dynamic spreadsheet while I'm choosing my next motorcycle. Now I click on the name of the bike I'm interested in, and apart from all the stats and pricing, I get a nice pic too.
That's a very nice application Mike :) Ride safely!
@Mike McLeod, how did you switch it from the drop down to just clicking on the name of the bike? I’m trying to do something very similar. Thank you.
@@mrmullin7 hey mate. I’ll happily email you the spreadsheet if you like.
Leila you are so good with Excel. I love the way you explain the steps. Thanks so much.
Woah! This is really amazing!! Didn't have the slightest clue that this could be done with Excel. Thanks Leila for sharing.
My pleasure David. Glad you like the tutorial.
Another piece of brilliance from Leila! This refreshed my knowledge of INDIRECT, Range names. Reminded me of forms controls too, sort of. Keep it up.
That's great! I'm happy to hear that! Thanks for your support.
This was something new to learn, thanks Leila. Btw Beautiful scenery
Great.
U r such a great teacher.
I learn lots from u.
Thnk u soo much ma'm
Thank you Leila, very useful and up to date! In order to avoid a grey frame around your flag, instead of cropping, you may also fill in the original cell in White.
May I ask how to do it🙏🏻🙏🏻i can remove the grey frame unless i un-do the "view gridline" on sheet "master"
@@marymary-vj3ze You can either crop like Leila did in the video or fill the cells (with the images in them) with white. the gridlines will disappear unless you draw borders.
Can't believe it works! Thanks a million!
Glad it helped
Thank you, soooo much!!!! Best youtube teacher in your sphere!)
I think you are the best
Once again, Leila, you wow me with your Excel prowess. I always learn something here. Thanks for the great value!
You're very welcome Scott. I'm glad you find the video helpful.
Leila You are great, because i like your explanation tone and manner
Something quite tricky - so simply explains. Thank you
Leila thank you very much, people asked me about this, today your video helped me to answer them. your video and effort is praiseworthy.
Thank You,
Mohammad Rashed Khan
Principal Instructor
New Horizons Dhaka, Bangladesh
This is better than that other video with index+match.
Dammmm!!!! I have been looking for this trick for like a year!!!!! Thanks a lot.
Really useful tutorial! Hope you're enjoying your holiday as well, Leila.
Thanks Andrew. Yes - as long as the sun is out, all is good :)
Excellent tutorial, as always!
You are AWESOME! Love your video's they are so easy to follow.
always you are the best Leila. your videos are on top.
wish the best for you in your life :)
Thank you!
It's bit tricky & lengthy. Your explanation is good, but so much steps To do. I'm sure you will come up with even better hack! 👍🏻😊
I stumbled upon your channel and I LOVE IT! Thank you so much for sharing these tutorials with us
You are so welcome, Julia!
I always apply your guidance into my work. It's very useful 👍🙂. Thank you so much
My pleasure 😊
Hi Leila, Another quality video.
The holiday spot looks great as well.
Cheers from Perth Western Australia
Thank you! I need to make a trip to Australia....during our cold winters :)
thank you very much, I am your student from Udemy with many course . you are amazing !
I'm glad you like the courses.
This is exactly what Im looking for, thank you so much Ms Leila muwaahhh , take care!
You're welcome 😊
Thanks for sharing this. Definitely the best video I could find on this subject. Very informative.
Glad it was helpful!
@@LeilaGharani I've gone back to this sheet that's been helpful over the years, and have run into an error for "Reference Isn't Valid". I'm not using pivot tables, so I think it has to do with Name Manager. Any tips on debugging?
The first time ever i took an excel lesson from outside that was brilliant
Glad to hear that!
@@LeilaGharani Thank you so much Leila
Thanks Leila! I learn a lot from you. -Ernie from philippines
Wow - 446k subscribers! Good for you! I've subscribed. Your videos cover so much ground (I just found this little nugget even though I subscribed a while ago), are easy to follow and your depth of knowledge is outstanding! Keep up the great work.
Awesome! Thank you!
Simply outstanding. Many thanks.
Our pleasure!
Good video! Did you know google sheets has a function =IMAGE(...) can render any image url as an image in a cell, then called back in VLOOKUPs, pivot tables, anything. Super easy approach and you don’t need to align anything. I learned super useful shortcuts like ctrl a and ctrl 1 for images!
No I didn't know that. I just tried it. That's amazing! Thank you for your comment. I learnt something new :)
Excellent video thanks for sharing 👍
Great content as always Leila, thank you so much for taking the time and making this available. Always enjoy your videos and insight with Excel. Thanks.
Thank you Monte for your kind comment and your support.
wow.....tough task made easier......by a great teacher.
Glad you think so!
This was an excellent tutorial! Probably saved me a whole day of messing around with VBA!
Glad to help although messing around with VBA can also be fun :)
Really fruitful...!! Thanks for the video.
Most welcome 😊
oh happy to comment From Iran
u r doing great Leila
i myself prefer video as short as possible
as fast as possible to the point
Your video is so much helpful, thank you.
Excellent pronunciation.. Keep it up!!!
Nice video, very well explained
What an awesome tutorial. You've just saved me a ton of time for my application. I'll be using it for product quotations where it's mandatory for products descriptions have a photo next to them.
That's great :) I'm happy to hear that.
I'm going to use Bill Szysz suggestion using the Indirect function he posted. Thanks again to you and Bill
Excellent excel explanation
BRILLIANT !!! Thank you for making this video
I really wonder why people are pressing unlike button? Thank you so much Leila, your videos are so much helpful
I was looking for this function, never thought this could be possible in excel. Thank you Leila
Awesome! Very straight forward and simple explanation.
name manager and indirect function, both very useful
Thanks Leila this was really very good i like it.
Great video Leila. Works well if the country name is single word, gets a bit untidy if the country name is more than a single word like South Africa. I don’t see a work around without the underscore on the range name and data validation.
Great video Leila! Always something new to learn
You're welcome Luigi.
Great learning guide. Excellent teaching style. Thank you!
Glad you liked it!
Fantastic Tip My Excel Guru!! I wish safety and wellness during this hard time of Covid-19. Thank you again for this tip, i am using this in my office dashboard. all my udemy subscription of your courses has been the most useful thing for me. so thanks!!! Take care excel guru...!!!!
You are welcome!
This is informative. thanks leila
Thank you very much for your tricks
it's useful. much appreciated, maam
Leila, you are a Good-sended angel!
😘
Really really helpful really appriciate ur edfort god bless u
This is amazing. One of the best thing I learned in 2021 🙌
Thank you Leila, I was waiting for this video since your last video. This video helped me a lot. Many thanks! Looking forward to your next video. Enjoy your time in Spain, looks absolutely wonderful!
I'm glad you find it useful! Thanks - yes one more video from here this week :)
Great video. I've subscribed.
Thanks laila its was perfect
Superb so well done and explained
Really glad you like it.
Thanks for the video. It's easy to follow, was able to implement the concept right away.
Thank you, this really helped Leila, just needed a little extra work as I needed to account for spaces.
Do you mean spaces in the naming? If so, I have the same problem and would love to know how you solved it :)
@@jeantaylor63 Hi Yes. I could have cheated and put UK put actually put United Kingdom. When I created the name, it puts an underscore (_) in place of the space. I therefore created another cell that replaces the space in United Kingdom with an underscore (Substitute Function) and use that as the reference for the "Flag" Name. I hope that makes sense.
@@stevereed5776 I thought that's what you might have done. At least I'm on the right track now. Thanks for responding.
@@jeantaylor63 Happy to send it if you have a contact address
Is there perhaps a way of changing the image not from a dropdown but on the active cell, so as you move through cells the image updates to a corresponding image relating to that cell
Excellent and impressive use of picture through indirect function.
How can i use for multiple cells more than 100. Have to type into each & every cells?
Hi Leila, I hope you are well. This is a great video that I have followed to the letter, but unfortunately my end result is #REF. I am using Excel 365, does your solution only work on 2019? My worksheet fails at the =Flag stage and gives me a "Reference isn't valid" error. Is there a simple step that is commonly missed by other people that I may have missed also?
I hope you can point me in the right direction. ***EDIT*** Figured it out - my names in my drop down list data have more than one word, when I named the cells containing the pictures excel replaced the spaces between the words with an "_" . As soon as I changed the names in my drop down list data to be exactly the same (ie with the "_" instead of a space) it worked perfectly. Thanks for a great video :)
Excellent explanation
Glad you like it.
Great video!
Thanks for your help. The pictures came over to the new document as you described, however when I made the new document into a PDF / print fille the pictures were not visible. Can you help?