Solved

# VLOOKUP TO BRING PICTURE

Posted on 2016-09-19
127 Views
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
Question by:Leonardo M
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 17

Expert Comment

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

ID: 41804583
Hi John,

Seen that article. Did not really help.
0

LVL 5

Accepted Solution

Yamaafg earned 500 total points
ID: 41805444
0

Author Closing Comment

ID: 41806117
Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns overâ€¦
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month5 days, 5 hours left to enroll