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 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?
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.
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!!!!
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 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.
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!
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.
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.
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!
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?
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.
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.
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
Great Video. Is there a way to connect using "-1" or "-2". I have configurations of a product that I need to show but when I try to use the -1 or -2 I'm not able to use that. Do you have any suggestions?
I know i'm late commenting here, but this video was great and just what I was looking for. Does anyone know how this can be set up to work on all cells in a column. So where I have a column of options, when one is selected then the corresponding image appears?
Is there a way to get the image in multiple cells without adding a new name every time? I am having approximately 50 cells where I need to keep repeating the same function. i.e. Every time I go to another cell, I have to copy paste picture in that cell and perform every steps again. Can we do it more faster for multiple rows? Any answer would be appreciated.
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...!!!!
Sir. Im from Philippines. Same Problem With Me. To Fix It. In The Formula. Change All , SIGN To This ; one. And No error PopUp. Sorry For My English Hahaha I'll hope It's help You
For those who receive a "Reference isn't valid" error message... Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it. Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
@@ExcelHubPro For those who receive a "Reference isn't valid" error message... Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it. Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
just add a new entry in your list of countries/flags called "None selected" or something, and create a blank flag image Then add "none" in your dropdown
@@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.