How to bring specific pictures into Excel

**Ted Von Kampen** · 02-07-2012, 02:12 PM

I currently use Excel as a design tool. While many of the normal equations, etc are obvious and easy to use, I cannot satisfactorily bring in a picture.
For example. I have 6 specific pictures that represent options on our product. In preparing the design and manufacturing spreadsheet, I will need to bring 1 picture on the main sheet. Pictures are contained on a page B. Depending on the PN entered for the product, I will want to select and place on the Page A a specific picture in a specific location on the page a. I know how to bring in a picture with the insert techniques, but I need a way to select only one picture and that is dependent upon the part number. I can deconstruct the part number without problem such that the PN represents one specific drawing.

For example: The PN is xxxxxxMA3. the A3 is one picture out of 6. the others may be A1, A2, B1, B2, B3, etc. I just want the one picture brought over, i.e.-the picture that shows what A3 option looks like.

So far I have not been able to find a way to bring just one picture over.

Any help would be appreciated.
Ted Von Kampen

**mrice** · 02-07-2012, 02:23 PM

There's a similar thread running which may get you the answer you need. Please let me know if you need more than this.

http://www.excelforum.com/excel-prog...-pictures.html

**Ted Von Kampen** · 02-07-2012, 02:50 PM

I will try it. Thanks

**mahju** · 02-08-2012, 06:51 AM

Hi
Here is another

1. Arrange the pictures in a colomn with one picture in one
cell. See sheet2 in attached
2. Copy any picture in sheet1.
3. Click on the picture and select name from insert menu
4. Click Define.
5. Type the name enter any name for range and in refer to use
index match function As
=Index(arrey, row,1)
Arrey is the column of pictures (f2:f3 in attached)
row is a match function
=Match(value to match, arrey)
Value to find: D5 in attached (Where you will enter picture code
Arrey Column where you have entered code for each picture
E2:E3 in attached
in attached it is

=INDEX(Sheet2!$F$2:$F$3,MATCH(Sheet1!$D$5,Sheet2!$E$2:$E$3),1)

6. Click add
7. Click the image and in formula bar type
=mylist and press enter
Now when you change code in d5, picture will also change automaticaly
If i can not explain anything see attached for more detail

Regards