Picture Lookup in Excel | 100% Guaranteed | Xlookup + Images = Fast & Easy | Photo Search Trick

The secret to creating quick and easy Picture/ Photos / Image Lookup in Excel in less than 5 minutes.

Do you know that we can use Excel formula to look for pictures, photos and images?
Including pictures in your excel file can help to make your file more exciting for your audience.
It can also help to tell better story. After all a picture can tell a thousand words.

However, I personally find it a little bit tricky setting an excel file with picture lookup up, as sometimes the lookup formula works and sometimes it doesn't.

After hours of trial and error, I have finally found a method that is guaranteed to work 100% of the time. In this video, I will share the secret to creating a file with picture lookup, using simple xlookup formula.

You will be amazed by how simple it is... as long as you follow the step by step approach that I outline in this video. Soon you will be able to master picture lookup / image lookup in Excel.

Hope this file will bring you lots of joy and that it will inspire you to infuse pictures and images into your excel file in the future...

Enjoy !!

Cheers,
Isabella Susilowati

#lighthouseanalytix #picturelookup #xlookup #imagelookup #excel #photoslookup

P.s. Whilst I have chosen to use Picture lookup technique using XLookup, I believe that the same principle can be applied with VLookup or IndexMatch combination... This is something that I haven't tried so I'd be very interested to hear if anyone of you has tried this. If so, please let us know in the comments section.

Time Stamps:
00:00 Introduction
00:11 Picture Lookup prelude
00:53 What are the Secrets to creating picture lookup in Excel?
01:26 Picture Lookup step by step
07:29 Conclusion

LA20

[GordonCrowe-yl]

Thanks for your help. The pictures came over to the new document as you described, however when I made the new document into a PDF / print fille the pictures were not visible. Can you help?

[suadahabdullah]

Hi, can we xlookup picture against numbers?
Example : 123 link to 🍎

[chevydavidson]

I'm getting a reference isn't valid error. I'm using a dynamic table so I can add information later, but it still looks it up. =XLOOKUP(B48, tblxmodel[Model], tblxmodel[Picture], 0) I use this as the defined name and when I try to rename the image I get reference isn't valid error. Please help

[jinmengqi]

is there a easier to quickly align the pictures in one column

[inlalabuot]

Hi when I apply name to pic it says reference invalid

[konicaparamasivam]

Very Nice ..Could you share your email