I firstly would like to appologise for this thread as I know it has been asked and successfully answered many times in this forum but I am at a loss on where to start.

I would like to know how to start a spreadsheet where I can select a product from a drop down list that then pulls in a picture from a database of pics elsewhere.

I need this to be within one spreadsheet so it is effectively portable.

I have tried downloading loads of the answers but cannot replicate other peoples efforts with any success.

Sheet 1 I want A1 to be my drop down list (validated to a name range A1:A10 on sheet 2 which I can do).
Sheet 2 A1:A10 to be the names, B1:B10 to be the picture name (is this Picture 1 etc as per the Excel reference when inserted ?) C1 I will place a pic and a different one in each cell down to C10.

I cannot see however how to link all this so on sheet 1 the picture is displayed dependent on A1

Any help would be so appreciated, havent got much hair and numbers are rapildy declining !!!




Due to company IT policies I can access very few websites and cannot download zip files. Fortunately can .xls !