Vlookup pictures!

[ALEZI]

Hello all

i have some post with same theme but i decided to start new bacause i change my sample,according to rules.

I tried to show pictures according to numbers code in my list on the sheet 2,
during the xploring of web i saw some examples with vlookup and data validation functionsbut i did't undestand this...

Please give some dorections or some samplesi do something wrong but i can't figure what is this.

Thank you in advance.

[newdoverman]

Here is your example file with a working drop down list and your pictures. I have tried to give the directions to repeat the process.

To add more pictures, increase the ranges as required in the Name Manager and make the changes to the vlookup table in sheet2 H2:I4 as necessary.

Make sure that you get the Paste Special Link Picture right or the whole process will fail.

[ALEZI]

Thank you for help,it works fine

Only one thing,i implement this in one my file and everything finei have problem when need to print this file,in print preview i do not see picture.

Do you have any idea way?

[newdoverman]

This could be a printer driver problem. Make sure that your printer driver is up to date.

If you insert a picture into another file, can you see the picture in Print Preview? If you can, are the pictures that you can't see in the same format as the ones that you can see?

I use version 2010 so this might be different in version 2007.

When you have a picture showing in Excel, click on the picture to select it. Right click and choose Size and Properties. Click on Properties. There should be a selection for Print Object. Make sure that it is selected. That is the only place that I can fine concerning the printing of objects.

[johnwatkins35]

newdoverman,
can you take it a step forward with the picture picking? like for instance, copying that pic you pick and paste it into another cell.

[newdoverman]

If you want a copy of the picture, right click on the picture so that the sizing handles are visible. Copy. Go to where you want the copy and Paste. When the original picture is changed, the copy will change with it.