How to Do a Picture Lookup in Excel

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

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-pictures-file

[@phoenixcrp]

Thankyou. I've been struggle with this topic as I don't have Excel 365. No other youtube tutorial helped me but yours.

[@your_shiin]

Great job. I appreciate. You are a natural born teacher. I owe you.

[@franciscoveras7405]

Leila I can’t get enough works to express my gratitude for the knowledge and help I get from your videos, Thanks so much !!!!!

[@LeilaGharani]

I'm really happy to hear that Frank! Thank you so much for your kind comment & support.

[@GlenAlbertoGuenther]

This is the first time I have seen image linking through name manager. Thank you for teaching us so clearly!

[@LeilaGharani]

You're very welcome, Glen!

[@peanutbutterjellybeans1336]

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!

[@messywebdev]

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 ❤️❤️

[@LeilaGharani]

Awesome! Thank you!

[@oyamayen8128]

Your video is the only reason I want to turn the notice from KZbin on, it helps me a lot !

[@muhammadhaneefattari5314]

This was something new to learn, thanks Leila. Btw Beautiful scenery

[@ASNNetwork]

I was looking for this function, never thought this could be possible in excel. Thank you Leila

[@volkanc.9364]

I Love You So Much Thank You So glad that I have you.. I learned a lot thanks to you..

[@swittpresales5470]

Excellent and impressive use of picture through indirect function.

[@fonzireyes]

never get tired of learning more excel. subscribed!

[@emiliaalejandrakuschnir5199]

This solution is AMAZING, many options in other videos were pretty complicated, but this is great, thanks so much!

[@LeilaGharani]

Glad you liked it, Emilia!

[@monte4955]

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.

[@LeilaGharani]

Thank you Monte for your kind comment and your support.

[@lanfofana1973]

Leila you are so good with Excel. I love the way you explain the steps. Thanks so much.

[@mariellamarrero7773]

Amazing. So clearly explained. Thank you.

[@nlopez2304]

Awesome! Very straight forward and simple explanation.

[@ckokse]

wow, great video. love the scenery.

[@ScottAnders62]

Once again, Leila, you wow me with your Excel prowess. I always learn something here. Thanks for the great value!

[@LeilaGharani]

You're very welcome Scott. I'm glad you find the video helpful.

[@christinestevens7900]

Brilliant as ever - thank you Leila!

[@IRG0203]

Dammmm!!!! I have been looking for this trick for like a year!!!!! Thanks a lot.

[@jother1304]

Thanks for the video. It's easy to follow, was able to implement the concept right away.

[@ebrindonmello377]

This is amazing. One of the best thing I learned in 2021 🙌

[@rohilla71]

Awesome - I am Impressed by the picture changing trick 🤠🆒️🤙🏻

[@privataye]

Awesome! I've been looking for that function with a drop down menu. Thank you for a great demo and instruction! 🤙

[@LeilaGharani]

Glad to help!

[@christianlam7372]

Thank you so much! Very user friendly. Great instructions.

[@frankkneeland955]

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.

[@PaulVass1]

Hi Leila, Another quality video. The holiday spot looks great as well. Cheers from Perth Western Australia

[@LeilaGharani]

Thank you! I need to make a trip to Australia....during our cold winters :)

[@jorgegarcia5062]

I love you Leila!!! I've been trying to link images for a week. Finally I could, tks to you!

[@bfflorida2311]

BRILLIANT !!! Thank you for making this video

[@gregnunes7702]

Something quite tricky - so simply explains. Thank you

[@juliarodriguez3861]

I stumbled upon your channel and I LOVE IT! Thank you so much for sharing these tutorials with us

[@LeilaGharani]

You are so welcome, Julia!

[@Cardiiee]

There’s always something to learn on your channel, I’m happy I found this channel. Well done Leila 👏🏽 👏🏽 👏🏽

[@LeilaGharani]

Awesome! Thank you!

[@MrPrakashsomani]

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.

[@LeilaGharani]

I'm glad you like the video!

[@spooncwru]

This was an excellent tutorial! Probably saved me a whole day of messing around with VBA!

[@LeilaGharani]

Glad to help although messing around with VBA can also be fun :)

[@johncurrie3900]

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!

[@DerickPitcher]

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.

[@LeilaGharani]

That's great :) I'm happy to hear that.

[@DerickPitcher]

I'm going to use Bill Szysz suggestion using the Indirect function he posted. Thanks again to you and Bill

[@ritheshkumarparemmal9400]

I'm done. Excellent it is working fine. With index-match also... Thank you Leila.

[@KAMINAHARAMILOL123]

Hi, can you help with Index Match formula here, not able to get it right Explain in brief or detail

[@simoninglis7437]

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.

[@LeilaGharani]

You're very welcome. Thank you very much for the kind words Simon!

[@jamessawyer8565]

I didn't know this. Thanks for sharing this trick with us

[@paulbrown6826]

You are AWESOME! Love your video's they are so easy to follow.

[@MelianusSapari]

Thank you very much for your tricks

[@AndreaCancinoJ]

Can't believe it works! Thanks a million!

[@LeilaGharani]

Glad it helped

[@sandeepkothari5000]

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.

[@LeilaGharani]

That's great! I'm happy to hear that! Thanks for your support.

[@ahmedelgammal5889]

Many many thanks Lila you are the best

[@fernandocamargo2637]

Thank you again for such a great content!

[@staceythienel3193]

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!!!!

[@LeilaGharani]

Cool, thanks Stacey!

[@vida1719]

That's amazing Leila. I never would have thought that it was possible to lookup picture

[@LeilaGharani]

I'm glad you like it Vida :) Excel is full of surprises!

[@ourscreatif]

Excellent tutorial, as always!

[@it-educator9735]

Leila You are great, because i like your explanation tone and manner

[@majorcrestolentino6863]

Great learning guide. Excellent teaching style. Thank you!

[@LeilaGharani]

Glad you liked it!

[@Hey_Dave]

Woah! This is really amazing!! Didn't have the slightest clue that this could be done with Excel. Thanks Leila for sharing.

[@LeilaGharani]

My pleasure David. Glad you like the tutorial.

[@andrewmoss6449]

Really useful tutorial! Hope you're enjoying your holiday as well, Leila.

[@LeilaGharani]

Thanks Andrew. Yes - as long as the sun is out, all is good :)

[@jessebacke]

Queen of Excel

[@munir14179]

This is cleaver approach. Thanks.

[@albertomascarenhas9010]

Your video is so much helpful, thank you.

[@shakhobiddinnakiev6767]

Thank you, soooo much!!!! Best youtube teacher in your sphere!)

[@mikeburrell2291]

Simply outstanding. Many thanks.

[@LeilaGharani]

Our pleasure!

[@gaddenis77]

Ты лучше всех! Very cool :)

[@prakashsrinivasan7840]

Excellent video thanks for sharing 👍

[@bluffmasterhara]

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!

[@LeilaGharani]

I'm glad you find it useful! Thanks - yes one more video from here this week :)

[@MarcoAntonio-yj4br]

Perfect! You totally solved my problem. Thank you so much!

[@LeilaGharani]

That's great Marco. Glad to help.

[@maxcarter3413]

Awesome! Many thanks from the island of Oahu.

[@adityaanugrah7952]

Thank you so much for sharing this tricks. This definitely Will save so much time for me to do my jobs.

[@danishwaghoo6924]

thanks for the lesson teacher

[@ibrahimaladam1184]

Great Job... I love the way you explain

[@whoknowsnone4138]

excellent, thank you so much

[@alvenbalatan7308]

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..

[@LeilaGharani]

You are most welcome

[@sirernz]

Thanks Leila! I learn a lot from you. -Ernie from philippines

[@horus4862]

That was a fun class, thank you

[@hariprasad3581]

Thank you for the video

[@ajitbanne3060]

Learnt something new.. Thank you👍

[@azashukri5322]

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.

[@LeilaGharani]

:) No April fools here :)

[@omarabdulmutalib6238]

Super, You are Amazing, thanks a lot!

[@sridharlagishetty2078]

Yes Laila I learn new things thank you very much.......

[@TheP01N]

Thanks you so much. It's more helpful for leaning.

[@trueseekertrue8068]

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

[@sto.cristoisregioniii-tarl2447]

This is informative. thanks leila

[@shahdabkhan2493]

Thank you so much.

[@shoaibahmedsagar]

Thank you Leila. I need this badly for my factory format. thanks a lot. :)

[@LeilaGharani]

You're very welcome. Glad this comes in handy :)

[@khibitn]

Sur I learned something new today, thank you too much

[@rudi-gruber]

Thank you Leila, very cool video

[@LuigiIzzo001]

Great video Leila! Always something new to learn

[@LeilaGharani]

You're welcome Luigi.

[@yulinliu850]

Big thanks for sharing!

[@LeilaGharani]

You're very welcome Yulin :)

[@mohamadfawaz1928]

you wowed me really as usual

[@martinpetrech7833]

Thank you. I love you. :) Great. Its working.

[@wesszep9865]

I like this. Thanks a lot.

[@juliusbiliran]

Wow! I am so impressed! I cant wait to use this in my excel sheet for our office Survivor pool. Lol! 😀😚 Thanks sooo much. I learned soo much from you.

[@LeilaGharani]

I'm glad you like it Julius. You have an office survivor pool? Do people get voted out too? :)

[@rbhumeshwar6313]

Really fruitful...!! Thanks for the video.

[@LeilaGharani]

Most welcome 😊

[@abdulbarisaleh561]

Thanks laila its was perfect

[@salmansarfarazss]

Really really helpful really appriciate ur edfort god bless u

[@user-km8nn6br8y]

thanks you

[@bandidphasengkeo5220]

I always apply your guidance into my work. It's very useful 👍🙂. Thank you so much

[@LeilaGharani]

My pleasure 😊

[@pintusir9781]

Great. U r such a great teacher. I learn lots from u. Thnk u soo much ma'm

[@superscott165]

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.

[@LeilaGharani]

Awesome! Thank you!

[@frankbradford9616]

Mind blowing!

[@MalinWale]

Great video!

[@imu2spm]

Thanks Leila this was really very good i like it.

[@gauravchopra181]

Nice video, very well explained