With Xlookup wildcard searching became very easy.... Thanks Chandoo...
2 жыл бұрын
You are amazing and the best man in the world
@Romariowll Жыл бұрын
BEAUTIFUL. I LOVE YOU
@papachoudhary54823 жыл бұрын
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
@cornucopia73292 жыл бұрын
I’m getting error “reference isn’t valid” after trying to replace image reference with employee_to_show
@silvana112211223 жыл бұрын
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
@chandoo_3 жыл бұрын
Thanks Silvana.. Wish you and your family a merry Christmas & happy new year 2021.
@wayneedmondson10653 жыл бұрын
Hi Chandoo. Very interesting technique! Looking forward to studying it further. Thanks for sharing :)) Thumbs up!!
@chandoo_3 жыл бұрын
Thank you! Cheers!
@canirmalchoudhary81733 жыл бұрын
This technique is very very unique because of Spilled functionality inbuilt within XLOOKUP.....
@chandoo_3 жыл бұрын
Thanks Nirmal :)
@elijahd.spragueph.d89053 ай бұрын
After typing name in the search box, how do you keep your cell from going to cell below after pressing enter?
@hazemali3822 жыл бұрын
always more than great Chandoo ♥
@joseagundis13 жыл бұрын
Thanks Chandoo, very very usefull and amazing it.
@Kash_if3 жыл бұрын
awesome technique! will surely apply this.
@DPSCHafizabad5 ай бұрын
can to insert picture from ay folder with same sense i.e. control by a cell content
@gamingworldhd9971 Жыл бұрын
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?
@suchitanikam43995 ай бұрын
Can we creaate same form multiple name manger in different sheet
@jessedunn3766 Жыл бұрын
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!
@Jojosmith342 Жыл бұрын
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
@user-qf2on8vv3l11 ай бұрын
Hi Chando, I cannot find the link to download the file, could you direct me?
@amitmittal24533 жыл бұрын
Awesome Sir, thanks for this technique :)
@chandoo_3 жыл бұрын
Most welcome!
@Ching-mw1is Жыл бұрын
it gives me an error "reference isnt valid", anyone help
@kannanmassey57832 жыл бұрын
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
@visuss13 жыл бұрын
Useful & Really Nice ! :)
@chandoo_3 жыл бұрын
Glad to hear that!
@sajjadsiddiqui28933 жыл бұрын
thanks for sharing, can image lookup be done through power query
@lexlucens3 жыл бұрын
hi instead of a drop down or search entries, can we use another image to move forward and backward? like a powerpoint sequence. thanks!
@elifdemir46622 жыл бұрын
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
@yurimichailov4383 жыл бұрын
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!!
@chandoo_3 жыл бұрын
Hey Yuri. Thanks for the comment. I suggest using fixed range. While you can do this with tables, there are no advantages for this particular situation.
@doras.31782 жыл бұрын
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.
@wilkbaywood11083 жыл бұрын
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?
@chandoo_3 жыл бұрын
Thank you Wilk. You can find linked picture under right click paste options
@accnotech38633 жыл бұрын
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.
@chandoo_3 жыл бұрын
Good point. Give it a try with the sample data and let me know how you implement it.
@rash93663 жыл бұрын
Awesome
@chandoo_3 жыл бұрын
Thanks Rash..
@rameshmendiratta76602 жыл бұрын
I am getting a blank pic, any solution please
@chandoo_2 жыл бұрын
Check your picture link logic. If you exclude the sheet name then the picture link might refer to the range on current sheet instead of the pictures worksheet.
@royb.mangubat97912 жыл бұрын
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
@chandoo_2 жыл бұрын
Not really. You can use VBA for these kinds of things. Here is my getting started with VBA tutorial - kzfaq.info/get/bejne/a9FdftOE0Ni2f6s.html
@rajanghadi23373 жыл бұрын
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)
@ChandooD3 жыл бұрын
Hi Rajan... Both are valid methods. This one shows few more tricks with XLOOKUP and fetching team members.
@bhushangadiya3 жыл бұрын
This doesn't work when I copy to other excel workbook. Is there a solution to this?
@chandoo_3 жыл бұрын
Not sure what you mean "when copying". See the download file and make sure all the names are created too.
@ibrahimezz43173 жыл бұрын
If I don't have xlookup yet another function is there any way
@ChandooD3 жыл бұрын
You can use INDEX+MATCH to the same thing. For example, XLOOKUP(A1, B10:B20, C10:C20) becomes INDEX(C10:C20, MATCH(A1, B10:B20, 0))
@izakonas3 жыл бұрын
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?
@chandoo_3 жыл бұрын
Hmm.. are you using Excel on desktop or some other tool (Excel online / open office etc.)? Also, check the reference name formula and rewatch the video if you have trouble.
@ubaidillahmuhammad203 жыл бұрын
useful kmowledge. May I have an excel file?
@chandoo_3 жыл бұрын
Please find the link in the video description.
@mdcs1992 Жыл бұрын
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.