How to Do a Picture Lookup in Excel
HTML-код
- Опубликовано: 20 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn to quickly lookup images based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell.
⬇️ Download the workbook here: pages.xelplus.com/lookup-pict...
📊 What You'll Learn:
▪️ Dynamic Picture Lookups: Discover how to perform lookups on pictures, a unique and practical Excel feature.
▪️ Real-World Examples: Understand the concept through real-life examples, including a FIFA World Cup tool that updates country flags dynamically.
▪️ Step-by-Step Guide: Follow a detailed walkthrough on organizing images, formatting them correctly, and linking them to data.
▪️ Name Manager & Indirect Function: Learn to use Excel's Name Manager and the Indirect function to make image lookups dynamic.
▪️ Practical Application: See how this technique can be applied for various purposes, such as employee photos, sales manager pictures, or company logos.
You'll also learn a few other techniques here. For example:
1. How to work with Excel's picture tools (Crop images, align etc)
2. How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option
3. A little bit about the INDIRECT function (find out more with the below link)
4. How to link pictures to cells
★ Links to related videos: ★
World Cup 2018 Sweepstake (with free template link): • FIFA World Cup 2018 Ex...
INDIRECT function: • Excel INDIRECT Functio...
Data validation basics: • Create SMART Drop Down...
Custom Data validation: • Excel Custom Data Vali...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-pictures-file
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!
Great job. I appreciate. You are a natural born teacher. I owe you.
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.
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 was something new to learn, thanks Leila. Btw Beautiful scenery
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!
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!
I Love You So Much Thank You
So glad that I have you..
I learned a lot thanks to you..
This solution is AMAZING, many options in other videos were pretty complicated, but this is great, thanks so much!
Glad you liked it, Emilia!
Your video is the only reason I want to turn the notice from RUclips on, it helps me a lot !
Leila you are so good with Excel. I love the way you explain the steps. Thanks so much.
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!
Thankyou. I've been struggle with this topic as I don't have Excel 365. No other youtube tutorial helped me but yours.
Excellent and impressive use of picture through indirect function.
I was looking for this function, never thought this could be possible in excel. Thank you Leila
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.
Thanks for the video. It's easy to follow, was able to implement the concept right away.
wow, great video. love the scenery.
Awesome! Very straight forward and simple explanation.
Amazing. So clearly explained. Thank 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.
Awesome! I've been looking for that function with a drop down menu. Thank you for a great demo and instruction! 🤙
Glad to help!
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?
I stumbled upon your channel and I LOVE IT! Thank you so much for sharing these tutorials with us
You are so welcome, Julia!
There’s always something to learn on your channel, I’m happy I found this channel. Well done Leila 👏🏽 👏🏽 👏🏽
Awesome! Thank you!
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!
Thank you so much! Very user friendly. Great instructions.
never get tired of learning more excel. subscribed!
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!
This is amazing. One of the best thing I learned in 2021 🙌
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 :)
You are AWESOME! Love your video's they are so easy to follow.
Brilliant as ever - thank you Leila!
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.
Thank you so much for sharing this tricks. This definitely Will save so much time for me to do my jobs.
Awesome - I am Impressed by the picture changing trick 🤠🆒️🤙🏻
Thank you again for such a great content!
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
I'm done. Excellent it is working fine. With index-match also... Thank you Leila.
Hi, can you help with Index Match formula here, not able to get it right
Explain in brief or detail
BRILLIANT !!! Thank you for making this video
I didn't know this. Thanks for sharing this trick with us
Dammmm!!!! I have been looking for this trick for like a year!!!!! Thanks a lot.
Something quite tricky - so simply explains. Thank you
Your video is so much helpful, thank you.
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 :)
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!
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.
Hi Leila! Thank you very much for providing such great things in excel in a very smart way.
I want to be certified MS Excel Trainer. Could you please guide what is the procedure?
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
Great learning guide. Excellent teaching style. Thank you!
Glad you liked it!
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
Thank you LG, I have learned so much from you. You are an excellent teacher. For the picture lookup, I clicked the image and went straight to the formula bar but the arrow didn't change to a cursor so, is it going to work with windows 10 too or newer?
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 :)
Many many thanks Lila you are the best
Excellent tutorial, as always!
Great.
U r such a great teacher.
I learn lots from u.
Thnk u soo much ma'm
Thanks Leila! I learn a lot from you. -Ernie from philippines
Leila You are great, because i like your explanation tone and manner
Great Job... I love the way you explain
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!
Perfect! You totally solved my problem. Thank you so much!
That's great Marco. Glad to help.
This is cleaver approach. Thanks.
Thanks you so much. It's more helpful for leaning.
Thank you, soooo much!!!! Best youtube teacher in your sphere!)
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!
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 :)
That was a fun class, thank you
Thank you very much for your tricks
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 :)
Yes Laila I learn new things thank you very much.......
Great place on earth. I like the style of the presentation. Learn something about our beautiful planet!
With images pasted over cells "and tagging along in data sorting", is it possible to return a cell reference of where the image has been placed, through an excel/vba enquiry?
I always apply your guidance into my work. It's very useful 👍🙂. Thank you so much
My pleasure 😊
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.
Thank you Leila. I need this badly for my factory format. thanks a lot. :)
You're very welcome. Glad this comes in handy :)
Super, You are Amazing, thanks a lot!
Hi Leila! Thanks for another great tutorial! I was wondering if its possible to do this with an active cell?
Excellent video thanks for sharing 👍
Learnt something new.. Thank you👍
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.
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!
Thank you Leila, very cool video
Hey it's really amazing, something new added to my to do list. It's a bit tuff one on different xls version.
Cheers!!
I'm glad you find it useful Allwyn :)
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?
Sur I learned something new today, thank you too much
Thanks Leila for your amazing tutorials. Can you help us with a solution to lookup list of items to have their pictures? not a drop list, a column of list.
Thanks again and again.
Great video. I did learn new things today. Thanks for sharing!!!
You're very welcome. Glad you found something new here :)
Great video Leila! Always something new to learn
You're welcome Luigi.
Leila, great walkthrough! You wouldn't happen to have any tips on how I could copy the completed dynamic image lookup down to the subsequent cells, would you? I tried using a relative reference for the defined name for the INDIRECT formula, but to no avail. Thanks for your invaluable content and training!
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
Awesome! Many thanks from the island of Oahu.
Thanks Leila this was really very good i like it.
Simply outstanding. Many thanks.
Our pleasure!
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...🤝?
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.
I like this. Thanks a lot.
Really really helpful really appriciate ur edfort god bless u
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 ruclips.net/video/CEM0pp5SjMU/видео.html
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.