Hi
maybe try:
http://www.mcgimpsey.com/excel/lookuppics.html

--
Regards
Frank Kabel
Frankfurt, Germany

"shashak" schrieb im Newsbeitrag
...

I have a data table with 10 columns (=10 properties) and 30 rows of
data
from my test samples. I have listed the names of the test images in
the
data table Column F as "test1", "test2", and so on. On my harddisk I
have stored the images corresponding to the tests in
"C:\CTParts\test1.bmp, test2.bmp,...".

Below this data table, I have a report table with multiple rows of
data. The report table uses validation list (referencing data table
column A) and fills some of the remaining cells in the report's rows
by
using the VLOOKUP function.

What I would like to do is to retrieve the .bmp image corresponding
to
the Column F value in the report table, (E.g. Column F row 35 value
by
VLOOKUP is "test1", then Column F row 35 will display the image
test1.bmp retrieved from "C:\CTParts"), and resize the row's height
to
fit the image height. All images have a fixed width but different
heights. The images need to be shrunk to 25% of their size, while
maintaining their aspect ratio and centered in the column.

Any help would be appreciated.
Shank


--
shashak
---------------------------------------------------------------------
---
shashak's Profile:
http://www.excelforum.com/member.php...o&userid=16265
View this thread:
http://www.excelforum.com/showthread...hreadid=276683