Referencing pictures from one excel worksheet to another 1

[davebbb]

I'm having problems referencing a picture contained in one worksheet by a cell in another worksheet. Basically, I have a spreadsheet of product details, including pictures of the products we manufacture. For our production purposes, we'd like to output the pictures on the jobsheet, contained in another workbook. One product may apply to several or many jobsheets, hence we'd like to reference it in the normal excel manner.

Many thanks if u can help

 

[Dreamboat]

Example:

Sheet1 = jobsheet, column A you put in product code, column B looks up item description, column C looks up picture

Sheet2 = database of job info, column A has product codes, column B has item descriptions, column C has pix (there are 500 rows on Sheet2)

Row 1 is always headings, so:

In Sheet1, cell A2, type a product code from the list in Sheet2.

In Sheet1, cell B2, put formula:

=if(vlookup(a2,Worksheet2!$A$1:$C$500,2,FALSE)="","Description not available",vlookup(a2,Worksheet2!$A$1:$C$500,2,FALSE))

In Sheet1, cell C2, put formula:

=if(vlookup(a2,Worksheet2!$A$1:$C$500,3,FALSE)="","Picture not found",vlookup(a2,Worksheet2!$A$1:$C$500,3,FALSE))

Email if it doesn't work or you need more help.

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com