Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to organize the relationship between two or more tables?

Hello !


How to organize the relationship between two or more tables?

or attach it to a table cell reference to another table or spreadsheet file?


Sorry for my English

iMac, OS X El Capitan (10.11)

Posted on Nov 21, 2015 1:58 AM

Reply
6 replies

Nov 21, 2015 3:43 AM in response to Atas80

Hi Atas,


Click in the destination cell (Table 2, Cell B2)

Type =

Click in the source cell (Table 1, Cell B2) or any cell

User uploaded file

Formula appears in Table 2, B2

=Table 1::B2

Press the enter key to confirm.


In Numbers, you can link between tables on different sheets (Tabs) within one file (document), but it is not possible to link between different files (documents).


Regards,

Ian.

Nov 21, 2015 5:41 AM in response to Yellowbox

Excuse me. I probably did not properly explained.

There are two tables: one with the list of demands, the other with a full calculation of the orders.. Identifirovat order can be for articles, which is listed in raschchete.

How to insert a link to another file tables?


Active cursor in string Art="2"


ArtName
1One
2Two
3Three
Art NamHeader 3Header 4Header 5Header 6

2

Twofdgsfdsdfsgfdsdsfsfdfdgdfgdfdfgsfdsggfdsfgds

Nov 28, 2015 11:52 PM in response to Atas80

Hi A'80,


Does this fit your request?

User uploaded file

Details is the 'catalogue' containing a list of items carried and information about them.


Main is the order sheet on which the Item Number is entered in column A.

Information in columns B through D is retrieved from the Details table using a Lookup function.


For the example, there is a single formula, entered into Main::B2, then filled right to D2 and down to the last row on Main.

All data on the Details table is entered directly. There are no formulas on this table.


Main::B2: =IFERROR(VLOOKUP($A,Details :: $A:$D,COLUMN(),FALSE),"")


Fill right to D2. Fill down to last row of Main.


FALSE here tells VLOOKUP to accept only an exact match when searching for the item number. If a match is found, COLUMN() tells VLOOKUP the column of the lookup table ("Details") from which to return the correct information.

Any value in column A of Main that is not found in column A of Details will cause an error. IFERROR traps the error, and places a null string ( "" ) in the cell containing the formula.


The formula shown is for a lookup table on the same Sheet as the Main table. If "Details" is the ONLY table in the Document with that name, the formula will be the same if Details is paced on a different Sheet from Main.


REgards,

Barry

How to organize the relationship between two or more tables?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.