I have found that I can add images to cells as background in Numbers in various sheets.
I'd like to reference these images in these cells from another sheet.
Is this possible?
Reference image in Numbers
numbers
Related Solutions
The short (and sad) answer is: No, unfortunately it is not possible.
I had the same sort of problem and with some help from people within the Apple Support community I came up with this solution. Hopefully it will work for you.
This is my list of players in sheet 1. In your case, the Players name would be the item codes.
Here is sheet where I want to information copied to.
The P# corresponds to the number next to the Players name in Sheet 1. If I enter a 1 and a 2 the names are filled in to the column to the left of the box.
This shows the formula required to transfer the players name from sheet 1 to sheet 2.
To take it a step further, when I fill in the Players winnings in Sheet 1 it also fills it in all the "Earnings" cells for that player in Sheet 2 using the formula shown below.
My list of players goes to 300 but the last 20 or so are empty. That way I can still add more names or in your case, item codes, to it.
This may be more complicated than you require but hopefully it helps you.
Best Answer
I don’t believe it is possible to reference the image in a cell of another table but you can simulate the effect with an appropriately filtered overlapping table.
One solution is to copy each of your images into a row or column with formulas in each cell deciding if the picture should be shown and use filter/sort options to show only the chosen sets. The formula results can be made transparent so only the image is seen. Conditional highlighting with custom transparent background can also be used to knock some sets out of view while preserving absential space so the images line up as they should, or alternatively to have a toggle switch to show/hide the picture.
Here are some tips I’ve found useful: If your images change frequently it’s helpful to use the same formulas for all cells using col() or row() as index holders for one dimension and a reference to header column or row as an index in another dimension. This minimizes maintenance time when new images are added. In this example, the 11 columns with olive-toned headers are all separate tables of one column and many rows. The formulas in each cell checks if a given title (represented by the position index) is present in a column of a book display (in the yellow table identified by the number in each olive header row) and the tables are then filtered for true values.
BTW, Here is the formula in each picture cell: CHOOSE(IFERROR(MATCH(LOOKUP(ROW()−1,Paperback Lookup::Table 1::$A,Paperback Lookup::Table 1::$B),CHOOSE(A$1,Book Plan::B,Book Plan::C,Book Plan::D,Book Plan::E,Book Plan::F,Book Plan::G,Book Plan::H,Book Plan::I,Book Plan::J,Book Plan::K,Book Plan::L),0)^0,2),TRUE,FALSE)