Lookup Picture in Excel 2019

[fareedexcel]

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.

 

[GraH - Guido]

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.

 

[fareedexcel]

Thanks @GraH - Guido for your update. In my organization, we are using MS Excel 2019 only. Could anyone advise please

 

[GraH - Guido]

You can go with old school: https://chandoo.org/wp/excel-image-lookup/

 

[fareedexcel]

@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

 

[Marc L]

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]

@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.