How to Use Excel's NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus Reveal

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Microsoft just released a new feature in Excel to insert pictures inside cells. It's called "Place in Cell". This allows us to create more advanced and professional looking Excel dashboards without the need for complex solutions. Inserting images in cells makes it easy to use functions like XLOOKUP or FILTER to return an image. You can now also lookup a picture and return the corresponding information on the same row. So that pictures can be provided as a lookup value to lookup formulas like XLOOKUP.
⬇️ Download the workbook here: pages.xelplus.com/image-in-cell-file
Availability: Microsoft 365 currently only in Beta Insiders channel.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 How to Insert Pictures Into a Cell in Excel
00:32 Insert Images in Excel Cell
02:20 Return Images With Formulas
04:00 Bonus - Lookup Images
05:58 Wrap Up
➡️ Join this channel to get access to perks:
kzbin.info/door/JtUOos_MwJa_Ewii-R3cJAjoin
🎬 LINKS to related videos:
Breaking News! We FINALLY get the Excel functions we've been Wanting!: kzbin.info/www/bejne/jIjGfYBslLaSZpI
How to Use Excel's New TAKE Function: kzbin.info/www/bejne/sGeZXmmNi7-GfLs
➡️ Join this channel to get access to perks: kzbin.info/door/JtUOos_MwJa_Ewii-R3cJAjoin
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: lgharani
LinkedIn: www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/image-in-cell-file

[@MaiteRodrigues-nw6in]

excellent! so much easier than the indirect function in a image !! thank you for the video

[@saracosta620]

I have been waiting for this feature for nearly 10 years. Thank you!

[@AL-ye5zz]

I love these videos where you blow our mind with new functions

[@markpodesta4605]

Thank you Leila. I use the IMAGE function in Excel right now.

[@mandoball1980s]

I’m getting an accounting position soon and I’ve been learning everyday from you. You are my education. My school. My hero 😊

[@sudeepashawan6836]

A big thumbs up to you for sharing such valuable information for free...💐💐💐

[@ronaldnayman4841]

Awesome! Thanks for sharing what you learn.

[@j.ballsdeep420]

Love to see you using proper tables and table references. People need to make this a habit, far easier once you learn it, but crucial when dealing with larger datasets instead of looking to an entire column *_shutter_*

[@TaylorMacD]

Thanks for your insight ballsdeep420

[@arbazahmad7177]

How awesome is this.. Thanks for bonus tip.

[@thiagarajanneelamegam8640]

Wonderful LG. Its really help me.

[@kirstinhartmann]

Hi Leila, thanks a lot for this great video. All Functions worked in the german version of excel as well.

[@user-nd1ol2vw9h]

But there are no "Place in cell" option in Excel. Only available "Insert picture from this device", "Stock images" & "Online pictures". How to add "Place in Cell" option?

[@Blessed_and_Fit_Over_50]

How do we get it?

[@joycenaicker6251]

That's awesome. Thanks for sharing 👍.

[@zachosen]

This is super useful ... just exatly what i needed thanks a million

[@mehul2011]

Wow, mind blowing. This one will change my reporting and a lot of grief working within MS Word. I am going to change all my templates from word over to excel now!

[@jasongraham731]

Wow that’s pretty cool 😎 Thanks Leila

[@patrickpointer8380]

This is brilliant !

[@taizoondean689]

Thank You .....really nice one

[@eslamfahmy87]

Perfect all of us love your videos

[@learningtogetheredu]

As a small KZbin who has a channel that also do educational videos i benefit a lot from bigger KZbinrs thank you. Wishing to grow bigger as well. Thank you for great information.

[@DinoDelight]

This is amazing and perfect for an upcoming project I have, I was gonna create a "get picture" function but it would be a lot of work

[@KernelDataRecovery]

Your videos are helpful

[@DGuyette]

This is awesome!! Thanks

[@nadermounir8228]

Interesting new feature, especially the picture lookup part

[@adnanakram2217]

i love Vlookup. So nice of u ma'am for sharing

[@lifewithm44]

I slowly start to like excel XD Thank you so much!

[@unnikrishnansanthosh]

Great one, thank you LG for sharing

[@LeilaGharani]

Thanks for watching.

[@RotaryTeamVincent]

Thanks for sharing.

[@learningwithmaliha]

Amazing!!

[@MrSupernova111]

Pretty cool! Cheers!

[@chrism9037]

Such a cool new feature. Thanks Leila!

[@LeilaGharani]

It really is. Hope it will be rolled out soon.

[@juanrsosa]

I thought it was already released, need this ASAP, already have my pics in a folder

[@NoSYRTV_123]

That's very nice i got new new ideas from you madam you are so great

[@farmarcos]

Thaks for updating us with this new feature in advance. This'll be very useful at my job when released.

[@LeilaGharani]

Our pleasure!

[@mar4kl]

This is mind-blowing to me. I find myself wondering how it works behind the scenes. I worked as a database programmer in the 1990s and early 2000s, first with Paradox, then Microsoft Access and eventually JSPs and Java Servlets with a SQL back end. I remember when Borland (Paradox) and Microsoft (Access) added binary large object (BLOb) fields to tables in their products. That was pretty neat, but BLOb fields weren't searchable. We also didn't tend to use them a whole lot, because the cost in terms of storage, disk access time, processing power and network bandwidth, if the database was stored on a server, was enormous. The database programmer also had to take into account that the application might have to run on a computer that wasn't capable of making use of whatever was stored in the BLOb field. That was both because a lot of computers in use at the time lacked the graphics hardware to display more than small GIFs, and because the BLOb field wasn't limited to pictures. Those aren't things we have to think so much about today, but I do have to wonder what happens to the workbook file size as you start adding images, and what happens to the search if the user loads up the column with full-size JPEGs.

[@LeilaGharani]

File size will definitely be an issue if loaded with high-res pictures.

[@avijain2230]

@@LeilaGharani Maybe it works because it is using a binary checksum of the image already in the workbook versus running some sort of image recognition on the machine or cloud? Perhaps test it by reducing the resolution of the original pic and saving it as a different filename and then inserting it into the lookup field?

[@ctg5561]

or it can possibly be the image name

[@mahendraroliya8695]

Excellent💯💯💯

[@sseemm]

Just wooow. thank you Leila

[@LeilaGharani]

Welcome!

[@hkchess2000]

This tutorial is cool, Thank you

[@LeilaGharani]

Glad you liked it!

[@gxsoft]

Hi Leila, Thank you for sharing very useful knowledge, Warm Regards, gab

[@LeilaGharani]

Glad you enjoyed it!

[@ibrahim82649]

This is AMAZING

[@arindambhattacharya7848]

Mind blowing ❤

[@hussainakhtar1094]

I have tried this on one of my workings and it worked. Thanks it's very cool. I'm truly impressed with its functionality; it's a remarkable solution. Thank you so much for sharing this amazing technique!

[@LeilaGharani]

Great to hear!

[@dustinkeier9176]

@leilagharani I absolutely love your videos! They have helped me in my work in soo many ways! Is there anyway you could show us a video that illiterate how to insert the date into a cell when you populate another cell(ie auto generate the date of change for a cell)?

[@AniManuSCh]

Wow that is amazong, imagine if it could also surprise us working in drop down lists

[@David-mu8hn]

Very cool!

[@Wasted-GTA]

Wow, this is fantastic. At 4 mins you mention looking up data by photo which is a game changer for my business. My question is, what if the photo does not completely match will it find the closes one that matches? I scan book covers to show condition, in my database there would be slight variance from photo to photo. One image is one book scan and if I scan a new image of a different book, but same title. Would it find similar book data from the first scan? I am dealing with 100's of thousands of lines. Thanks for the great video.

[@WalkWithTiger]

Awesome video

[@samuelorozco3439]

Just the other day I found a fairly old how-to article (somewhere on the internet) on how to do this the "old school" way, using INDEX(MATCH() for a named range and such. This is so much easier

[@nigelwaxley]

That's what I have been doing. It's a pain

[@Pi314...]

I have to upgrade my Excel to get this new tool. However, I was curious what would happen if you sorted the table using the pictures. Also what does the pull-down filter look like?

[@EmronWalker]

I used GPT to create a VBA solution for a colleague just a few weeks ago. He analyzes images of license plates against the text value produced from OCR. We had unique file paths to the images listed in the worksheet. The VBA code inserted the image next to the path. The OCR text values were there too for comparison. I wonder if this functionality you’re sharing would allow my solution to be done without VBA.

[@SkiAdventurer]

That's great, like you said in beta right now so I don't have access. I'm curious can you use a data variation on the images to get a dropdown list of images. You could then scroll through the list of images, pick the one you want and get the name.

[@hatimalhaj7792]

You are the Best!!! Thanks for sharing. I have two questions please. 1. What impact on the size of file, any performance issues may occurs due to adding several pictures? 2. I tried to add pictures from SharePoint using IMAGE formula, but no luck. Is it the same with this new feature? Once Again Thank you Leila for the awesome video! .

[@thandartun179]

Miss you are my leader.

[@BilingualbabiesA]

Thank you for the tutorial, really helpful. Is there a way for excel to read hand written information, scanned and saved as pdf? I thought to use the get data function and from PDF but it seems excel can’t read the hand written information. Do you know of a better way please?

[@andrewcharlesmoss]

It’s good to see IMAGE evolving. I’d still like to be able to concatenate images in the same cell.

[@LeilaGharani]

Agreed. There is definitely room for improvement.

[@Ruddigore]

Wow, this is exactly what I need, I can't wait for it to be come out of Beta.

[@LeilaGharani]

Me too :)

[@shaystibelman]

props for reminding everyone that google sheets had this ages ago by naming your photos folder google sheets tutorials.

[@PeterNickson]

This is brilliant. Next level would be if a mail merge from Excel to word could pick up images as fields. Can you test this out please?

[@AccroExcel]

thanks😄

[@pt3470]

At last this is available!

[@hassanraza-vb5ss]

this is so cool 😎 😎

[@chandrasekharreddy800]

You're an amazing resource! I'm learning so much from you, You're my Guru Dronacharya.

[@LeilaGharani]

Wow, thank you!

[@donalcunningham1225]

Super Moon this week!🌝

[@imunbi]

Thanks for the video. I hope this means that the picture can be used to mail merge into MS Word 😊

[@tiger131071]

Great that this will finally be possible as it already has been in google sheets for ages. Question - If I develop a spreadsheet using this and then pass it onto someone else who doesn't have the beta functionality available...will it still work for them?

[@syedbarkathussaingilani324]

Awesome

[@coenraadthiart1254]

Hi. Thanks gorgeous the video. When i import the pictures the rotate 90 degrees to landscape, is there a way to fix this?

[@workstuff5253]

Nice!! Is there a way to feed in a valid image URL and get the image in cell?

[@FilmGrouch]

Wild!

[@KaanSiyasal]

I'm using Microsoft365 Business and all office updates have been done. But I can not see "Insert into cell" in pictures sub-menu. Is this new property specific to some other 365 versions or hasn't it issued to all users yet?

[@KaanSiyasal]

Oopss, sorry. I realized that I missed the banner "Currently in Beta" at the beginning of the video.

[@user-dn3ji5bl3o]

Would be great if we could have Pictures in a dropdown list.

[@augustodemelo915]

I truly appreciate the value of this amazing feature, and I believe it would be incredibly beneficial for my projects. However, I regret to inform you that I currently lack access to this excellent capability.

[@marwanattya8067]

Excellent But I want to know if it's possible to make droplist from the pictures Thanks so much

[@harisshlunanii507]

Thanks for making video regarding the Insert Image in Cell feature. It is currently only available in Microsoft 365 online. I have Excel on Macbook. Waiting for this feature on the macbook.

[@LeilaGharani]

For desktop you will have to join Office Insider. Let's hope it rolls out soon.

[@fieryzou9321]

I am all excited to give it a try. Only to find out this feature is not available yet for my Microsoft 365😢. Hope it will be available for everyone. Can't wait! It is really cool feature, can be very useful for my work.

[@vivaindian]

WoW!👌

[@GeekandTea]

Sadly I do not have this function. Great video!

[@gilsonlabasan1981]

Hello. Do You have a video before regarding automated customer number? Thank You

[@martintayler23]

Well Leila, MS are either slowing the release or only allowing it for particular versions as my copy of Excel (Microsoft® Excel® for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit ) does not have this feature. Hopefully, it will appear soon.

[@2000sunsunny]

Hello Leila! I am using Office 365 and I dont have Place in cell" option in Excel. In which version is it available? Thank you for tutorial.

[@KadWave1]

Hi Leila, I appreciate your videos & it's very helpful! I'm in the 365 insider program & running Excel Version 2309 Build 16.0.16827.20014 & I still don't see this place in cell function, any ideas?

[@AP-eb8hd]

Nice feature... I think excel is hashing the picture and uses that as a lookup value.

[@jtrindle9383]

Do you lnow if this will be on the sharepoint version of Excel?

[@skc471]

This is really interesting and most useful, however the option of "Place in cell" not showing in my excel office 365 version. Do I need to do some steps to activate. Please suggest.

[@antunklaic9943]

My dear Leila, I must tell you this. You are Amaisyng Teacher. Evrytime wen I forgot to use the $ sign in the Index/Match formula, after #NA sowing, your Beautiful Face pops up in my mind And the sentence uses F4 for Index Match. It is incredible phenomena in human brain, how it memorises some things. I must say, I am very happy wen your face pops up in the stressful environment.

[@LeilaGharani]

Glad to be of service 😁

[@jsobreira90]

I would love this "insert in cell" but for checkboxes, like you have in Google Sheets.

[@wolf34501]

instead of directing copying the image that is in the array to the cell where xlookup function is looking, you insert the same image file ,same folder to the cell using the new "place in cell", will lookup still functioning or it will be a error?

[@DickvanderVelde]

Have you tried if using the image for lookup is based on the original file that you inserted? Hard to believe it actually searches by the actual image.... so, wondering what kind of info it is looking for, or what happens if you add 2 different images but with the same name....

[@BillTheScribe]

Will this be able to insert the image in a mail merge? We have 200 locations, each needs a unique printed page with a series of QR codes to link to various social media platforms. We've been making them manually. It is... unpleasant.

[@Locomaid]

The image search works when using a photo copied from the table it has been inserted into. Does it work if you copied in the same image directly from your laptop? Is it using image metadata or excel cell metadata (or whatever, experts please correct) 🤔

[@mel-bp1lr]

The best Excel Video channel ever. I have a question about inserted images. Every time I double click on the cell that contains the image the text shows up and the picture disappears. It's a big drawback because if someone clicks on the picture by mistake you lose your information. Any Idea how to deal with this problem?

[@sunitapaudel]

Hi Leila. Is it possible to do PDF files instead of pictures? Would be very helpful in my work. Thanks

[@prince-68818]

Awesome. I need one help from u.

[@AndrewGammie]

Is there a way to insert a picture from the clipboard rather than from a file location using VBA, or an ActiveX button? I have a sheet I've been looking at making where screenshots need to be copied in, but saving them to the computer would become quite tedious

[@mosesntsieni9607]

Wow!

[@82chandar]

Your videos are helpful, I have a doubt. In Data Validation drop down list, is it possible to use expand or collapse on sub group? For ex: I have L1 -> L2 -> L3 levels to use expand to select the option

[@duyenkhanh1695]

Dependent drop down list indirect function

[@ashishnatani7238]

Index- Match function is working only with one cell and there is data validation is a must. What do if need an Index-match function to link images in each cell of a column, like in a quotation. When enter SKU no in Cell B2-B10, then images come in Column E2-E10 but is without data validation(no drop down list). Please help for this concern

[@boerharms2209]

what version of Excel are you on? Mine doesnt seem to have the add image to cell function

[@pbond21]

F I NA L Y !!! I have waited forever for this feature, to add images from one sheet several times in another table by choosing it from a dropdown or other reference method. So hopefully that works now. Thanks!! Edit: Tried it today and sadly can't see the feature (365), it's still the old "Insert image from...". I also can't find the feature in the release notes (German). My current version is: Microsoft Excel für Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64 Bit. Could it be that it's just not yet released globally? Thx again

[@smartandsimpleSNS]

The Excel queen strikes again!