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

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

@LeilaGharani

6 жыл бұрын

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

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!

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

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

@LeilaGharani

3 жыл бұрын

You're very welcome, Glen!

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

2 жыл бұрын

Awesome! Thank you!

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

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

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

6 жыл бұрын

Thank you Monte for your kind comment and your support.

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!

@LeilaGharani

2 жыл бұрын

Glad you liked it, Emilia!

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

never get tired of learning more excel. subscribed!

wow, great video. love the scenery.

Excellent and impressive use of picture through indirect function.

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!

Brilliant as ever - thank you Leila!

Awesome! Very straight forward and simple explanation.

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

@LeilaGharani

5 жыл бұрын

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

Amazing. So clearly explained. Thank you.

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

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

5 жыл бұрын

I'm glad you like the video!

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

I love you Leila!!! I've been trying to link images for a week. Finally I could, tks to 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.

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

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

@LeilaGharani

4 жыл бұрын

Glad to help!

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

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

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

@LeilaGharani

2 жыл бұрын

Awesome! Thank you!

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

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

@LeilaGharani

4 жыл бұрын

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

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

5 жыл бұрын

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

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

@LeilaGharani

3 жыл бұрын

You are so welcome, Julia!

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

5 жыл бұрын

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

@DerickPitcher

5 жыл бұрын

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.

@KAMINAHARAMILOL123

3 жыл бұрын

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

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

6 жыл бұрын

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

BRILLIANT !!! Thank you for making this video

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

@LeilaGharani

6 жыл бұрын

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.

Something quite tricky - so simply explains. Thank you

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

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

4 жыл бұрын

You are most welcome

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

@LeilaGharani

5 жыл бұрын

My pleasure David. Glad you like the tutorial.

Thank you again for such a great content!

Many many thanks Lila you are the best

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

6 жыл бұрын

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

@LeilaGharani

3 жыл бұрын

Cool, thanks Stacey!

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

@LeilaGharani

6 жыл бұрын

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

Excellent tutorial, as always!

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

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

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

5 жыл бұрын

:) No April fools here :)

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

Queen of Excel

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

@LeilaGharani

4 жыл бұрын

That's great Marco. Glad to help.

Your video is so much helpful, thank you.

Sur I learned something new today, thank you too much

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

5 жыл бұрын

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

Great learning guide. Excellent teaching style. Thank you!

@LeilaGharani

3 жыл бұрын

Glad you liked it!

That was a fun class, thank you

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

This is cleaver approach. Thanks.

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.

@LeilaGharani

4 жыл бұрын

Awesome! Thank you!

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

@LeilaGharani

6 жыл бұрын

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

Again come up with new excel trick . Your excel skills are simply awesome and it is helping me a lot in my work.

@LeilaGharani

6 жыл бұрын

Thank you! There is still so much more I have to learn - that makes it fun though :)

Awesome! Many thanks from the island of Oahu.

Can't believe it works! Thanks a million!

@LeilaGharani

4 жыл бұрын

Glad it helped

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

@LeilaGharani

6 жыл бұрын

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

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

Super, You are Amazing, thanks a lot!

Great video Leila! Always something new to learn

@LeilaGharani

6 жыл бұрын

You're welcome Luigi.

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 :-)

@LeilaGharani

5 жыл бұрын

So true!

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

I like this. Thanks a lot.

Simply outstanding. Many thanks.

@LeilaGharani

3 жыл бұрын

Our pleasure!

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.

@LeilaGharani

5 жыл бұрын

That's a great tip. Thank you!

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

Big thanks for sharing!

@LeilaGharani

6 жыл бұрын

You're very welcome Yulin :)

Learnt something new.. Thank you👍

you wowed me really as usual

Thanks for sharing this. Definitely the best video I could find on this subject. Very informative.

@LeilaGharani

4 жыл бұрын

Glad it was helpful!

@petroswheels

Жыл бұрын

@@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?

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

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.

@LeilaGharani

4 жыл бұрын

That's a very nice application Mike :) Ride safely!

@mrmullin7

2 жыл бұрын

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

@MrMikey1703

2 жыл бұрын

@@mrmullin7 hey mate. I’ll happily email you the spreadsheet if you like.

Totally loved this video, I was actually wondering how to make something like that! I love your content, keep going like this! I also your student in udemy on several courses and they are worth it! Have a nice day Leila!

@LeilaGharani

6 жыл бұрын

Thank you so much Damian! Glad you like it. And thank you for your support of my Udemy courses. I'm happy to hear you find the content valuable. Wish you a nice day too : )

Thank you very much for your tricks

Thank you Leila, very cool video

The first time ever i took an excel lesson from outside that was brilliant

@LeilaGharani

3 жыл бұрын

Glad to hear that!

@p2kc1

3 жыл бұрын

@@LeilaGharani Thank you so much Leila

You are easily my favourite Excel guru 👍

@LeilaGharani

4 жыл бұрын

So nice of you

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

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

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

@LeilaGharani

2 жыл бұрын

My pleasure 😊

Interesting approach. So far I always used Index & Match, but this solution is unique. Thanks Leila !!

@LeilaGharani

6 жыл бұрын

You're welcome Victor.

@akpokemon

2 жыл бұрын

wait I think I need your solution :( lol I have 85 rows to do this with...Do I have to make 85 names?

@Victor-ol1lo

2 жыл бұрын

@@akpokemon kzread.info/dash/bejne/dXmBktKpZbbQfbg.html

Great video. I did learn new things today. Thanks for sharing!!!

@LeilaGharani

6 жыл бұрын

You're very welcome. Glad you found something new here :)

Hey it's really amazing, something new added to my to do list. It's a bit tuff one on different xls version. Cheers!!

@LeilaGharani

6 жыл бұрын

I'm glad you find it useful Allwyn :)

Mind blowing!

Excellent video thanks for sharing 👍