• 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

  • Picture Lookup.xlsx
    69.1 KB · Views: 4
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

  • Picture Lookup.xlsx
    69.1 KB · Views: 1
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