[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1237
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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