Ok, Excel Gurus, here is my issue;

I have one worksheet that contains my data (About 10,000 entries). Simple worksheet, columns, rows and data in between.

On a second worksheet, I created a form (Using again, basic worksheet). Ok, before anyone asks, NO, I cannot use 'UserForms', NO, I cannot use ACCESS. This must be a basic EXCEL worksheet for security, simplicity and sanity sake. Anyways, I only have 1 active cell on this second worksheet. In it, based on the user's selection, EXCEL (Using VLOOKUP, populates the remained of the fields (About 200)). Now, 4 of there cells are where Images (Or pictures) need to go.

So, my question is this: I would like, in the first worksheet, type in the location (Or better), simply create a hyperlink of the location of the image, to be saved localy. Now, on the second worksheet, when the user makes the selection, in those four cells that are reserved for the images, I would like the actuall image to show up, sized according, automaticly in the selected cell. Something like what VLOOKUP does with data, only, with an image.

So, 1. Can this be done? and 2. HOW!

A thousand thanks in advance!

D'