assigning an image a value

[gtg653t]

Hello,

I hava a huge database with pictures that correlate to specific model numbers. I need to create another sheet with the same pictures correlating to the same numbers in a different format. So I tried doing an Hlook up but the images are not recognized by excel as cells to be referenced at. Is there way to do this because I really don't want to manually copy and paste 2000 images.
Any help is greatly appreciated!!!

Thanks!!

Andrew

[Leith Ross]

Hello Andrew,

Shapes don't have a value property like a cell. I am sure we can find a way to make this work for you, but first, you need to post more about the layout of the worksheet and the data it contains. You could also post your workbook.

Sincerely,
Leith Ross