• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup Picture in Excel 2019

fareedexcel

Member
Hello Experts,

I have attached an excel sheet with 2 tabs, Input and Output, the output sheet should lookup the input sheet and fetch the information.

The result should be as per the Output Sheet. Kindly advise.
 

Attachments

In Excel 365 you can paste pictures inside cell. Then XLOOKUP or VLOOKUP works.
I never worked with Excel 2019, so I'm hesitant to say it will work.
Attaching the file nevertheless.

1718910503348.png

1718910526157.png
 

Attachments

Hello, as you asked in the Excel Question forum section so just use the same formula within cells like demonstrated with post #4 link …​
Another old school way is VBA.​
 
@GraH - Guido. This helps in only fetching the image to one cell from a base sheet. But I need to do a VLOOKUP Image for multiple cells
It's the same principle. But it involves some set-up of named ranges, yes.

I'm unfortunately not familiar with the features of 2019 version, and the Microsoft help pages I found, do not explicitly say it's excluded from versions.
Can you check if you have this option "Pictures" -> "Place in Cell"? If so, then my first solution might work too.
1719246100934.png
 
Back
Top