You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I'm wondering if there is any way to link changes in Numbers between worksheets. Say the price of an item goes up or down in the inventory worksheet is there any way to have the price change appear in the manufacturing worksheet so the price of manufacturing is changed at the same time?
iMac, macOS High Sierra (10.13.6)
Hi kindida,
A "Sheet" in Numbers refers to a blank canvas on which one or more Tables (and other objects may be placed).
If the price you refer to is in a cell in a table on one sheet, and is transferred to the other sheet by a formula in the cell in a table on the second sheet, then changes in the first cell will automatically cause changes in the second cell.
Example:
Inventory Sheet contains one Table, named Table 1
Item name is in column A of this table, item price is on the same row of column C.
Manufacturing Sheet contains one table, named Table 1.
Item names are listed in column A, starting at row 2. Item prices are to be placed in column C.
In C2 of this table, enter the formula below:
VLOOKUP(A2,Inventory::Table 1::A:H,3,exact-match)
Fill down for as many rows as you have items and prices to listN
The formula tells Numbers to search, in the leftmost column of columns A to H of the named table, for the value in A2 of, 'this table', and when it finds an exact match, to return the value from the same row of the third column of the named table to 'this cell'.
Other data about the same item use the same formula, with the number (3) changed to match the column containing the data required.
H in the formula is the last column of the table on the Inventory Sheet. evise to fit your case.
If the item names to look up are in a column other than A (of the table on the Inventory Sheet) replace A with the column containing the item names, This must be the leftmost column of what you are defining as the lookup table. It is also column 1 with respect to the return column (3 in the example).
Regards,
Barry
Hi kindida,
A "Sheet" in Numbers refers to a blank canvas on which one or more Tables (and other objects may be placed).
If the price you refer to is in a cell in a table on one sheet, and is transferred to the other sheet by a formula in the cell in a table on the second sheet, then changes in the first cell will automatically cause changes in the second cell.
Example:
Inventory Sheet contains one Table, named Table 1
Item name is in column A of this table, item price is on the same row of column C.
Manufacturing Sheet contains one table, named Table 1.
Item names are listed in column A, starting at row 2. Item prices are to be placed in column C.
In C2 of this table, enter the formula below:
VLOOKUP(A2,Inventory::Table 1::A:H,3,exact-match)
Fill down for as many rows as you have items and prices to listN
The formula tells Numbers to search, in the leftmost column of columns A to H of the named table, for the value in A2 of, 'this table', and when it finds an exact match, to return the value from the same row of the third column of the named table to 'this cell'.
Other data about the same item use the same formula, with the number (3) changed to match the column containing the data required.
H in the formula is the last column of the table on the Inventory Sheet. evise to fit your case.
If the item names to look up are in a column other than A (of the table on the Inventory Sheet) replace A with the column containing the item names, This must be the leftmost column of what you are defining as the lookup table. It is also column 1 with respect to the return column (3 in the example).
Regards,
Barry
price changes across multiple worksheets
