Please help with a formula in Numbers

Depends what you mean by "spreadsheet."

A Numbers Document is a "Spreadsheet Document"

A "Spreadsheet document" contains at least one Sheet, and that Sheet contains at least one Table.

The same Document may contain additional Sheets, and each of the Sheets may contain more than one Table.

Within the same Document, what you ask is possible. The formula would be entered in the cell to which the name would be copied, and could be of the form

IF(cell1="paid",cell2,"")

where "cell1" is the full address of the cell containing "paid", and "cell2" is the full address of the cell containing the name to be copied to the cell (on a different Table, possiby on a different Sheet) contaning the formula.

If the Table containing the target cell is in a separate Document, this cannot be done using a formula. Numbers Documents cannot 'talk with each other."

Regards,

Barry

PS: The formula suggested above is for a simple case. Even assuming your situation does involve tables within the same document, it is likely that the details of your case would require a different formula to provide a solution. A more specific description of those details may help provide a solution.

B.

""cell1 from sheet 1 sheet 2 sheet 3 etc. and cell2 form sheet 1 sheet 2 sheet 3 etc. all sending to one master sheet?

Yes, but there are a couple of vocabulary items to clear up:

Cells in spreadsheets do not 'send' data to other cells (or to any destination. Formulas in cells in in spreadsheets can collect data from other cells in the same Document. Stated in other words, data is 'pulled', not 'pushed'.

Cells are in Tables, not on Sheets. Tables (and other objects are on Sheets.

Table names must be included in the cell address for any cell (or range of cells) on a table that is not the one containing the formula referencing the cell(s).

Sheet names must be included in the cell address only if the Table containing the referenced cell(s) has the same name as one or more other Tables in the Document.

For your example, let's suppose all of the referenced tables have the same name, Data, and the Sheets they are on are named with the names of the month whose data they hold.

The formula retrieving the data will get the data from cell B2 of each table, and will place it in row 2 of the column designated for the month matching the name of the Sheet containing the Data table for that month.

The Data tables will look like this example for May. B2, the only cell relevant to the example, contains 1005 (1000 + the month number equivalent to May) The other Data tables contain 1001, 1002, etc.

The Summary table (on Sheet 1) has columns labeled with the month names, starting with January in column B. The labels on these columns must be an exact match for the month names used for the Sheet names.

The formula shown below the table is in cell B2 of this table (Summary).

INDIRECT constructs a cell address as a text string, using the contents of the cell in row 1 of its column as the Sheet name, and the text following the concatenation operator ( & ) for the separators ( :: ), Table name ( Data ) and cell address ( B2 ) from which the data is to be retrieved.

As the formula is filled right to other columns, the B$1 reference will change to match the column containing each copy of the formula. The reference to cell B2 is fixed text in the formula, and is not incremented.

In column B, the formula is retrieving data from the cell at January::Data::B2. In column F, the same formula is retrieving data from the cell at May::Data::B2, shown on the first image in this post.

Regards,

Barry

Hi Randy,

"do I use this formula in addition to the "if, then" formula from the first reply?"

The formula you use depends upon the job you want that formula to do.

You need IF if the formula is to return one result IF a specific condition or set of conditions is met and is to return a different result if that condition or set of conditions has not been met.

If the formula is to always return the value from a specific cell, with no conditions set on performing that action, then you do not need IF.

Without a precise description of the task the formula(s) is(are) to perform, and a detailed and precise description of the structure of the data )and the locations of the data) the formula will be working with, it's not possible to provide a formula specific to that task and that data.

I'm not looking over your shoulder. I can't see what you can see. A screen shot or two might be useful. A description (with far more detail than has been so far provided) would also be useful.

Regards,

Barry