In this video, you will learn how to LOOKUP a picture /image in Excel.
While there are functions in Excel (such as VLOOKUP, HLOOKUP, INDEX/MATCH) to lookup and fetch a value from a list, to do a picture lookup in Excel, you need to use a little bit of workaround.
This would involve the lookup formulas as well as named ranges.
To do a Picture lookup in Excel, you need to have the images and use named ranges to fetch it.
I take an example of the football clubs from the English Premier League to show you how the logo appears when you select the club’s name from a drop-down.
There are four parts to creating this picture lookup in Excel:
1) Getting the data set ready.
2) Creating a drop-down list to show item names (club names in this example).
3) Creating a Named Range
4) Creating a Linked Picture.
Picture lookup (Image lookup) technique can be useful when you have a list of products with names (or list of companies with logos) and you want to quickly select one of the products and want the picture to update automatically.
This can also be a really cool lookup technique when you’re creating dashboards. You can make a selection change and as soon as you do it, the entire dashboard updates including the images/logos in it.
You can read more about this tutorial here:
⚡ Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
📌 This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.
⚡ Please subscribe to this channel to be the first to know when new Excel tutorials come out –
You can find a lot of useful Excel resources on the following site:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thanks sir .how do photo with ID num type in cell.
This is amazing! I’m so excited. This is the first useful new excel trick I’ve seen in far too long. Thank you so much!!
Getting Error Reference is not Valid
Christ, old excel use to just automatically snap an image and you could resize in cell….
செம நண்பா 👍
I've watched this 100 times and still get an error "This formula is missing a range reference or a defined name" EVERY TIME!!! So frustrated!
I now have a very useful, compact order form with lookup images! Who knew?!. Thanks for the trick!
Once I figured it out….Perfect results! THANKS!!! Worked like a charm! (I had to put the data used on the same sheet as the picture. I was trying to pull data from another sheet, and not having any success.)
Ultimate tutorial on Picture look up in MS Excel. I linked so much. It has cleared all doubts related to picture lookup.
Thanks a lot. The only challenge I have with picture lookup is removing the background and border without losing the picture quality. I can't seem to get around this.
hi, can you do this with gif?
THANKS A LOT SIR
Why should Arsenal on top? I can't find this team in EPL standing. Don't know where…
Do you know why my 'linked picture' looks cropped?
thank you!
Hey can anyone offer any help? Im trying to link my active x buttons to display a certain logo on a dashboard that i am creating.
This worked perfectly for what I needed! Great explanation as well!! One upgrade I had to create was using an INDIRECT function within this formula because the cell I was referencing wasn't one with a drop down menu (It was actually a cell with a formula that was dependent on a few other inputs). Basically, I wanted the final results of the formula (within the cell) as a trigger for the picture I wanted displayed.
So…within the formula you have, right after the MATCH function, I have an INDIRECT function for the cell I'm referencing. So instead of
"=INDEX($B$3:$C$22,MATCH($E$3,$B$3:$E$22,0),2)" …….I used "=INDEX($B$3:$C$22,MATCH(INDIRECT("$E$3"),$B$3:$E$22,0),2)"
This gives the "$E$3" cell the ability to be a variable cell with multiple different values, instead of a "data validation" list, and the quotes around the cell reference only takes the cell value.
Posted this in the hopes this may help others. 🙂
شكرا
reference isnt valid.. i followed everything
Hi Great Video just what i needed. I am having an issue though with it returning the image from the cell i lookup. I can return text but no image. Can you please advise? I have basically pasted lots of images into the cells within the cell boundary, but still not returning an image. Thanks in advance for any assistance.
Dear Sumir, Thanks for the tutorial. Very interesting. Just one challenge,,, I tried it step by step and I could get the same result. I have to submit a dashboard on social media data (queries from FB, Twitter etc,) and therefore I want to use the icons instead of the names. Please help me? I have a table from 2019 Jan to date…. I look forward in hearing from you. Dashboard is due Monday, 10 Feb 2020
Thank you very much sir for the picture lookup video. So simple and easy to understand.
Excel Changes my hyperlinks WHY ? How do you make a hyperlink that CAN NOT BY TAMPERED WITH
Need Help… i completely understood the process however i need to lookup images into new sheet for entire coloum and not the drop down list.
It doesn't work it gives a wrong cell
Thanks for the tips! My picture links keep appearing cropped even though the source cell has the image at the correct size within the cell. Do you know how to fix this?
Hi, I had insert pictures into cell & link picture as per video but there isn't any picture show after I insert my name formula. Do you know the root cause?
The tutorial does not specify which version of Excel this technique will work in. It doesn't work in 2010 so far as I can tell.
Brother After Lookup Picture no show in print file but other picture show please help me
Sumit, Terrific trick and works like a charm. In my case the Names and Logos were on a separate sheet to my main worksheet within the same workbook and it worked first time. Have duplicated similar "lookups" in other workbooks/worksheets and they all work perfectly. Thanks, keep up the great tips.
Thank you ! However when I try to do that between 2 work sheets in the same document it doesn't work! Could You tell me how I can do it ? thank you so much.
If I don't use data list I want cell to cell picture without use drop down list how is it possible to capture match picture
Not working!!!! Invalid refernce error shows
This formula is helpful for my task. Thanks.
But I cannot apply it in another sheet. can you recommend one of your videos with the said topic?
Hi Sumit, can I paste (link picture) in different sheet
thanks a lot, sir.
thank you Sumit! This is very helpful.
Thank you very much, this information is exact;y what i needed. Hope for future content on excel!
Hi Summit , I done same thing for me the error is reference is invalid for this u can make a video how to correct this one it will helpus to correct
Very useful video. Explained in easily understanding way. Thank you very much
Too many arguments error in formula shows when I entered formula index(cells,match(cell, cells,0,2))
please guide me
Hi Sumit many thanks indeed. I tried to follow another video without success, but your explanations were very clear and I have now got my test version working as per your examples.
Your video tutorial awes me! Thanks. 🙂