Tags: cell, comand, excel, goal, link, microsoft, msdn, particular, picture, picute, pull, software, ultimate, vlookup
How can I link a picture to a particular cell in excel?
I am trying to link a picture to a particular cell using Microsoft Excel. My
ultimate goal is to us a "VLOOKUP" comand to pull up whatever picute is
referenced in the VLOOKUP command. So far I can't find a way to accept the
object in the cell reference.
Leave a comment...
- 1 Comments
- For a VBA solution:
For a non-VBA solution:
Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.
Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
2)Build your data validation list on a cell in Sheet1 and pick one of the
3)Create a dynamic range name that refers to that cell:
...or whatever cell you chose.
4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.
5)With picture selected, type this in the formula bar, then press [Enter]:
The picture will be replaced by the picture referred to by the dropdown list.
Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.
Does that help?
> I am trying to link a picture to a particular cell using Microsoft Excel. My
> ultimate goal is to us a "VLOOKUP" comand to pull up whatever picute is
> referenced in the VLOOKUP command. So far I can't find a way to accept the
> object in the cell reference.#1; Thu, 22 May 2008 19:07:00 GMT