With Xlookup wildcard searching became very easy.... Thanks Chandoo...

You are amazing and the best man in the world

BEAUTIFUL. I LOVE YOU

Wish You and Your Family a very very Happy New Year 2021. GREAT fresh look at new year . Thanks! Kindly make some video on POWERBI

I’m getting error “reference isn’t valid” after trying to replace image reference with employee_to_show

Hi Chandoo , thanks for sharing I will be having a shot ! have a safe and merry Christmas with family and look forward to your videos in 2021

Hi Chandoo. Very interesting technique! Looking forward to studying it further. Thanks for sharing :)) Thumbs up!!

This technique is very very unique because of Spilled functionality inbuilt within XLOOKUP.....

After typing name in the search box, how do you keep your cell from going to cell below after pressing enter?

always more than great Chandoo ♥

Thanks Chandoo, very very usefull and amazing it.

awesome technique! will surely apply this.

can to insert picture from ay folder with same sense i.e. control by a cell content

this is good but i need pickup images from my drives its possible, i have total 25 images in my drive i dont paste individually in excel i want excel pickup images from my selected folder?

Can we creaate same form multiple name manger in different sheet

Beware of using this in a workbook with VBA "for" and "with" loops. It seems to slow code execution down by a factor of 11 (eleven)! Remove the linked picture object and you're back to normal speed again. You can verify by re-building the picture object and re-running. Things go back to slow as molasses and almost crashing during execution. I can't figure out exactly whats going on here, but I'd guess a bug. Took months to figure out why macros were running so slow!

Thanks for your video. Can you load the picture directly from local/network drive instead of the picture from the other sheet? Ex: once user enter EmployeeID, it will load the picture of that employee from the drive where there are hundreds of thousands employees' pictures. Thanks a lot

Hi Chando, I cannot find the link to download the file, could you direct me?

Awesome Sir, thanks for this technique :)

it gives me an error "reference isnt valid", anyone help

Hi, very informative tutorial. Sir I need guidance regarding : Instead of storing the no. of pictures in a worsheet is it possible if I select a unique rollno or sno from a dropdown it fetches the image from the path given in the worksheet adjacent to rollno eg Rollno Path 10001 d:\photo\10001.jpg 10002 d:\photo\10002.jpg So on . Kindly guide

Useful & Really Nice ! :)

thanks for sharing, can image lookup be done through power query

hi instead of a drop down or search entries, can we use another image to move forward and backward? like a powerpoint sequence. thanks!

Hi Chandoo, I used Vlookup, formula works in a cell. But when I put tje vlookup formula to the name manager, I got "reference is not valid" error :( Any idea about that? Thnaks

Hi!. First of all, sorry for my English... The video is excellent!. I tried to do this exercise with a table (I inserted a table), but I couldn't do that (I had problem with the references). Is it possible do using a table?. Thank you. Greetings from Uruguay!!

Hi Chandoo, It's a cool way to lookup pictures, thanks for sharing. I am wondering if you can share how to lookup pictures out of the same file. What I mean is I type the name of what I want to look up a product, for example, just type the product code eg. #12345 in an excel file or any worksheet that also could do the lookup.

hi chandoo, your tutorial is awesome and then i'm following this tutorial step by step but i can't find *Paste Special -> Linked Picture* in Excel 365, can you help me please?

that was interesting, i just had a thought what if, there are two gayatris working in my organization, which data am I going to visible,, obviously the first one, so can we trick it where we get options on the side, asking if you are looking for Gayatri Lastname 1 or Gayatri last name 2 or say Gayatri from management dept. or Gayatri from tech dept.

Awesome

I am getting a blank pic, any solution please

Do you have an excel tutorial where I'm going to upload a picture then it will automatically placed inside a shape (like circle or square) in other sheet? thanks

Why so long cut sir? Already you had explained this long long ago using INDIRECT. Even this can be used by INDEX,MATCH or OFFSET. I remember your file which was using INDIRECT (Select Chart to Display)

This doesn't work when I copy to other excel workbook. Is there a solution to this?

If I don't have xlookup yet another function is there any way

Hello, thanks for the video. This doesn't work for me, because when you click cell H5, you have a special variable "dynamic picture" and my excel doesn't do this just by clicking. Can you explain? edit: also, if I take out in your file example the "=employee_pic" that is in the picture, and then insert it again, it has the same issue as me "Reference is not valid", so I'm a bit surprised by doing the exact same thing, it does not work. Is it my excel?

useful kmowledge. May I have an excel file?

You need to point out at the start, that this only works for Microsoft 365. I just wasted watching and following along with half the video......no good if you have Office 2019.

Noice.

Why the salary of Gayatri is less than Jackie :-)