Solved

VLOOKUP TO BRING PICTURE

Posted on 2016-09-19
4
38 Views
Last Modified: 2016-09-20
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
Comment
Question by:Leonardo M
  • 2
4 Comments
 
LVL 13

Expert Comment

by:John Tsioumpris
ID: 41804442
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
 

Author Comment

by:Leonardo M
ID: 41804583
Hi John,

Seen that article. Did not really help.
0
 
LVL 5

Accepted Solution

by:
Yamaafg earned 500 total points
ID: 41805444
0
 

Author Closing Comment

by:Leonardo M
ID: 41806117
Thanks
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now