[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 842
  • Last Modified:

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
0
Leonardo M
Asked:
Leonardo M
  • 2
1 Solution
 
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
 
YamaafgCommented:
0
 
Leonardo MAuthor Commented:
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now