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.

Steps to link a picture to a particular cell in Excel:

1. Insert the picture you want to link into your Excel worksheet by clicking on the "Insert" tab in the ribbon, then selecting "Pictures" from the "Illustrations" group. Choose the picture you want to insert and click "Insert."
2. Click on the picture to select it, then right-click and choose "Format Picture" from the context menu.
3. In the "Format Picture" pane that appears on the right side of the screen, click on the "Size & Properties" icon (it looks like a paintbrush).
4. In the "Properties" section, look for the "Alt Text Description" field. Type the cell reference you want to link the picture to in this field (e.g. "A1").
5. Click "Close" to exit the "Format Picture" pane.
6. Now, when you use the VLOOKUP function to pull up the picture, you can reference the cell that the picture is linked to. For example, if you linked the picture to cell A1, you could use the following formula to pull up the picture in another cell:
   Formula:

   =VLOOKUP("value",A1:B10,2,FALSE) 


That's it! Now you can link pictures to specific cells in Excel and use them in your VLOOKUP formulas.

For a VBA solution:
http://www.mcgimpsey.com/excel/lookuppics.html

For a non-VBA solution:
Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(ToolsOptionsView tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. InsertPicture 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:
InsertNameDefine
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
InsertNameDefine
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
....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]:
=ShowMyPic

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?

***********
Regards,
Ron

XL2002, WinXP-Pro


"scottykaminski17" wrote:

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.