The intent is to create a sheet that references orders from customers with an image of each item ordered from my catalog of inventory.
I need to create a spreadsheet that references item SKUs to display an image of a unique item. For example: 004 entered in cell A:1 should lookup 004 on sheet "images" and return the value in column 2 that matches 004. I have successfully created this formula using the VLOOKUP function.
However, I want Numbers to populate the image in the resulting cell. The way my formula currently works it will only return the text in the cell. How do I get it to return the image value? If I delete the text out of the cell corresponding to 004 the result returned is 0 even though there is an image pasted into the cell.
Current formula:
VLOOKUP($A2,images::Table 1::A$1:B$10,2,FALSE)
I had dragged images from the Finder into cells but it appears as though they only show up as background images in the cells or something like that.