macosnumbers
My need is to compare content cells from two different sheets in the same file and get the cell value from another column of the first one.
This is the tested formula to find the right position:
ADDRESS(MATCH(B;Sheet1::Table 1::$I);7;4;1;)
it gives, for example, G12 in a relative cell in the second sheet, but I need the value of "G12" cell from the first sheet.
How can I do this?
The great thing about numbers is they offer a great how-to guide. If you don't know how to do something then all you have to is start typing a formula and it will begin to auto populate, click on it and the functions sidebar will open with the function. it will give you examples, what the parameters are etc.
That's just a tip, but your lucky I'm here:
Since you didn't specify what you want the cell of Table 1 to count in the column of table 2 I just counted all non-blank cells. You can alter with whatever text based of the countif function in the second example that compares against a string:
1 : Table 1 Cell that stores number of cells in column A of Table 2. As described since you didn't specific I just counted all non-blank cells :
=COUNTIF(Table 2::A,"<>"&"")
2 : Table 1 Cell that stores number of cells in Column E of Table 2 that matches text "MATCHED" :
=COUNTIF(Table 2::E,"MATCHED")
Instead of typing you can just do this:
Type into the cell = then type COUNTIF then click on the column header (E) it will select the entire column, then click on condition and type "MATCHED" then press enter! Your outcome will be based off this :
Therefore currently this is not possible.
Best Answer
ADDRESS has an optional parameter specifying the table name for the reference which can span across sheets by specifying the sheet name before the table name.
ADDRESS returns a cell address string which can be used to look up the value located in the referenced cell using
INDIRECT(addr-string, addr-style).