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.
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.
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 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.
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!
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.
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!
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
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.
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.
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.
Thanks for this it works well unless you have Data Validation drop down lists, as it stops the drop down selector arrows from being view-able, be warned!
@@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?
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.
I agree with @frankkneeland as most other tutorials somehow always miss out a tiny but important detail for those of us who are not excel proficient. Thank you Leila.
I really enjoy your videos! They are so helpful and your explanations are better than everyone else's on youtube. I watched several other videos trying to get the picture lookup to work and I should've known better than to stray from my most trusted source. After I got my formulas to work and I thought everything was great, I noticed one little issue - the drop-down arrows on my spreadsheet do not appear beside the cells as before. Before I added the picture lookup, the arrows appeared to the right of the cells as long as the cell was selected. Now the arrows flash for a split second and in order to click them, you have to imagine where they would be and just click. They still work as before, but those less familiar with excel (as most of the users of my spreadsheet are) will probably have difficulty with this. I noticed that on your video, you seemed to have the same issue at 8:45. I was hoping that, if you'd ever encountered this issue, you might have a way to correct it or a suggestion for alternative ways to make it function.
Thanks! I learned a couple of usefull things with your video. There is only one small improvement I would make. I'm sure you already know it becouse there is a lot of pro stuff in this chanel, but I try to explain it if someone find is usefull. Problem: If you have a lot flags, let's say 100, instead of 6, your name manager is going to be crowded. That is messy You can avoid that by replacing your "Indirect" function in the "Flag" name manager with a combination of "Index" and "Match" The new name manager would be something like this: list_Countries= Master!B3:B8 list_Flags=Master!A3:A8 input= Report!C2 Flag= Index(list_Flags;Match(input;list_Countries;0);1) I hope it helps someone.
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...!!!!
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 :)
Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-pictures-file
Thankyou. I've been struggle with this topic as I don't have Excel 365. No other youtube tutorial helped me but yours.
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!
This solution is AMAZING, many options in other videos were pretty complicated, but this is great, thanks so much!
Glad you liked it, Emilia!
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!
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 :)
Your video is the only reason I want to turn the notice from UA-cam on, it helps me a lot !
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.
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 appreciate. You are a natural born teacher. I owe you.
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!
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!
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.
I'm glad you like the video!
I love you Leila!!! I've been trying to link images for a week. Finally I could, tks to you!
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!
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!
never get tired of learning more excel. subscribed!
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 :)
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
Something quite tricky - so simply explains. Thank you
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!
Leila You are great, because i like your explanation tone and manner
I really wonder why people are pressing unlike button? Thank you so much Leila, your videos are so much helpful
Thank you so much for sharing this tricks. This definitely Will save so much time for me to do my jobs.
wow.....tough task made easier......by a great teacher.
Glad you think so!
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?
thank you very much, I am your student from Udemy with many course . you are amazing !
I'm glad you like the courses.
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!
Great.
U r such a great teacher.
I learn lots from u.
Thnk u soo much ma'm
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.
Thank you, soooo much!!!! Best youtube teacher in your sphere!)
Simply outstanding. Many thanks.
Our pleasure!
Leila you are so good with Excel. I love the way you explain the steps. Thanks so much.
Your hair looks so perfect when it's in a Ponytail! :) Great tips btw!!
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 :)
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
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.
Dammmm!!!! I have been looking for this trick for like a year!!!!! Thanks a lot.
Excellent pronunciation.. Keep it up!!!
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
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.
Can't believe it works! Thanks a million!
Glad it helped
This is better than that other video with index+match.
name manager and indirect function, both very useful
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.
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! 👍🏻😊
always you are the best Leila. your videos are on top.
wish the best for you in your life :)
Thank you!
Excellent excel explanation
This is exactly what Im looking for, thank you so much Ms Leila muwaahhh , take care!
You're welcome 😊
Excellent tutorial, as always!
The first time ever i took an excel lesson from outside that was brilliant
Glad to hear that!
@@LeilaGharani Thank you so much Leila
Excellent and impressive use of picture through indirect function.
Really fruitful...!! Thanks for the video.
Most welcome 😊
This was something new to learn, thanks Leila. Btw Beautiful scenery
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!
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 :)
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
Thank you very much for your tricks
Queen of Excel
You are AWESOME! Love your video's they are so easy to follow.
I Love You So Much Thank You
So glad that I have you..
I learned a lot thanks to you..
Great Job... I love the way you explain
I stumbled upon your channel and I LOVE IT! Thank you so much for sharing these tutorials with us
You are so welcome, Julia!
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 :)
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.
I was looking for this function, never thought this could be possible in excel. Thank you Leila
Really really helpful really appriciate ur edfort god bless u
Awesome! Very straight forward and simple explanation.
Thanks for this it works well unless you have Data Validation drop down lists, as it stops the drop down selector arrows from being view-able, be warned!
it happen with my dynamic dropdownlist.. it stop to works
Thanks Leila! I learn a lot from you. -Ernie from philippines
BRILLIANT !!! Thank you for making this video
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?
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.
This is amazing. One of the best thing I learned in 2021 🙌
Thanks laila its was perfect
it's useful. much appreciated, maam
I always apply your guidance into my work. It's very useful 👍🙂. Thank you so much
My pleasure 😊
Nice video, very well explained
This is informative. thanks leila
Excellent video thanks for sharing 👍
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 :)
Leila, you are a Good-sended angel!
😘
Your video is so much helpful, thank you.
Great learning guide. Excellent teaching style. Thank you!
Glad you liked it!
I agree with @frankkneeland as most other tutorials somehow always miss out a tiny but important detail for those of us who are not excel proficient. Thank you Leila.
Thanks for the video. It's easy to follow, was able to implement the concept right away.
thank you 1000 times, as I wanted this from last one month. since we need to confirm artwork from cutomer and by size and name.
That's great! I'm glad it comes in handy :)
i hope i can share my work by email to advise me if I can improve or change something.
Superb so well done and explained
Really glad you like it.
Excellent explanation
Glad you like it.
Interesting approach. So far I always used Index & Match, but this solution is unique. Thanks Leila !!
You're welcome Victor.
wait I think I need your solution :( lol I have 85 rows to do this with...Do I have to make 85 names?
@@akpokemon ua-cam.com/video/CEM0pp5SjMU/v-deo.html
I really enjoy your videos! They are so helpful and your explanations are better than everyone else's on youtube. I watched several other videos trying to get the picture lookup to work and I should've known better than to stray from my most trusted source.
After I got my formulas to work and I thought everything was great, I noticed one little issue - the drop-down arrows on my spreadsheet do not appear beside the cells as before. Before I added the picture lookup, the arrows appeared to the right of the cells as long as the cell was selected. Now the arrows flash for a split second and in order to click them, you have to imagine where they would be and just click. They still work as before, but those less familiar with excel (as most of the users of my spreadsheet are) will probably have difficulty with this.
I noticed that on your video, you seemed to have the same issue at 8:45. I was hoping that, if you'd ever encountered this issue, you might have a way to correct it or a suggestion for alternative ways to make it function.
First of all I'd like to say that you are looking very beautiful in this video and as you used INDIRECT function in this video that is amazing...🤝?
Thanks! I learned a couple of usefull things with your video.
There is only one small improvement I would make. I'm sure you already know it becouse there is a lot of pro stuff in this chanel, but I try to explain it if someone find is usefull.
Problem: If you have a lot flags, let's say 100, instead of 6, your name manager is going to be crowded. That is messy
You can avoid that by replacing your "Indirect" function in the "Flag" name manager with a combination of "Index" and "Match"
The new name manager would be something like this:
list_Countries= Master!B3:B8
list_Flags=Master!A3:A8
input= Report!C2
Flag= Index(list_Flags;Match(input;list_Countries;0);1)
I hope it helps someone.
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!
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 :)