Is there a VLOOKUP or XLOOKUP that can return images?

[c.clavin]

Hi guys, I made a table with 5 columns, so when I do a lookup for the 1st column, I'm trying to return the image in the 5th column. Each image is well within the cell boundaries. Is there a way to do this? I spent a long time getting the images into these cells and now I think I may have spent all this time for nothing. Please help!!

 

[Fluff]

Have a look here Picture Lookup in Excel using Named Ranges

 

[c.clavin]

I get a 'reference isn't valid' error when I follow the exact steps. Any idea why? On a Mac. Thought this would be it too..

 

[Fluff]

At what point did you get the error?

 

[jeremy_norbury]

For anyone returning to this - XLOOKUP, INDEX/MATCH can return images now (2/2025).