VLOOKUP TO BRING PICTURE

Dear EE experts,

How to bring a picture using vlookup  or vba code for the result. You can find a sample file attached.

In Sheet "sample" I would like to bring image in column "E" based on entries in column "D" using the pictures from Sheet "pictures".

Thanks.
ee-vba-lookup-code-to-bring-picture.xlsx
Leonardo MAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
John TsioumprisSoftware & Systems EngineerCommented:
There is an article on Excelguru where with a bit of trickery you get to Vlookup pictures
The article is here
Essential you are copying the first picture cell as linked picture and then your vlookup takes care the rest for the other cells...
There are some restrictions like image should be smaller than the cell.
0
 
Leonardo MAuthor Commented:
Hi John,

Seen that article. Did not really help.
0
 
Leonardo MAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.