VLOOKUP, but for images - Dynamic Image based on user input - Excel Trick

A while ago, someone asked me "how to show an image dynamically based on user input?". In this video, let me show you what I call "VLOOKUP for images". This powerful trick lets you display employee photos, product images or other such things based on user input.
For a sample file & more discussion visit
chandoo.org/wp/excel-image-lo...
for more about XLOOKUP, see this video - • What the function - XL...
#ExcelTricks

[@canirmalchoudhary8173]

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

[@Kash_if]

awesome technique! will surely apply this.

[@joseagundis1]

Thanks Chandoo, very very usefull and amazing it.

[@hazemali382]

always more than great Chandoo ♥

[@Romariowll]

BEAUTIFUL. I LOVE YOU

[@amitmittal2453]

Awesome Sir, thanks for this technique :)

[@chandoo_]

Most welcome!

[@silvana11221122]

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_]

Thanks Silvana.. Wish you and your family a merry Christmas & happy new year 2021.

[@sajjadsiddiqui2893]

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

[@papachoudhary5482]

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

[@lexlucens]

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

[@visuss1]

Useful & Really Nice ! :)

[@chandoo_]

Glad to hear that!

[@doras.3178]

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.

[@wayneedmondson1065]

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

[@chandoo_]

Thank you! Cheers!

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

[@kannanmassey5783]

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

[@rash9366]

Awesome

[@chandoo_]

Thanks Rash..

[@wilkbaywood1108]

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_]

Thank you Wilk. You can find linked picture under right click paste options

[@yurimichailov438]

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_]

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.

[@elijahd.spragueph.d8905]

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

[@canirmalchoudhary8173]

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

[@chandoo_]

Thanks Nirmal :)

[@accnotech3863]

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_]

Good point. Give it a try with the sample data and let me know how you implement it.

[@royb.mangubat9791]

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_]

Not really. You can use VBA for these kinds of things. Here is my getting started with VBA tutorial - kzbin.info/www/bejne/a5yQfKOJoNeFhdk

[@cornucopia7329]

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

[@ubaidillahmuhammad20]

useful kmowledge. May I have an excel file?

[@chandoo_]

Please find the link in the video description.

[@DPSCHafizabad]

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

[@suchitanikam4399]

Can we creaate same form multiple name manger in different sheet

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

[@elifdemir4662]

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

[@user-qf2on8vv3l]

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

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

[@ibrahimezz4317]

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

[@ChandooD]

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

[@bhushangadiya]

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

[@chandoo_]

Not sure what you mean "when copying". See the download file and make sure all the names are created too.

[@Ching-mw1is]

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

[@rajanghadi2337]

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)

[@ChandooD]

Hi Rajan... Both are valid methods. This one shows few more tricks with XLOOKUP and fetching team members.

[@rameshmendiratta7660]

I am getting a blank pic, any solution please

[@chandoo_]

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.

[@izakonas]

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_]

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.

[@geianmarkdenorte9874]

Noice.

[@chandoo_]

😍

[@neerajs.3112]

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

[@chandoo_]

haha.. as RANDARRAY() that...

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