What I am trying to do is use some kind of function like VLOOKUP or MATCH or something that will reference a cell with pictures in it from another sheet in the workbook. I linked a couple screenshots of the sheets I am talking about within my workbook.
The sheet tab "BOL" is where I am trying to get the pictures to reference to from sheet "Chemwatch". I tried VLOOKUP in cell "BC29" on the" BOL" Tab to pull from "Chemwatch" tab cell "N91" but can't figure out why its not working.
Maybe there is some way to fix the picture's in the cell's to the cell itself but I'm not sure. If there was some way to attach my workbook to the forum I would but I have not found where I can attach files. If anyone could help I would highly appreciate it. I have over 2,000 products that I deal with at work and all of the products have to have the "Pictograms" in order to be GHS compliant with DOT Transportation Laws. The current system we use at work is constantly messing up and the only thing that is holding me up from finalizing this program is to figure out how to reference pictures from 1 sheet cell to another. Thanks again for any help I can get. If the pictures do not show up after I post this I will figure out how to get them to post correctly.
Last edited:
