Forum Discussion
madeleine101
Aug 18, 2019Copper Contributor
Table syncing
I am currently writing an excel workbook to analyse material contents of various yachts for Life-Cycle analysis and was wondering if you may be able to help solve an issue I have? Attached is an ...
madeleine101
Aug 19, 2019Copper Contributor
SergeiBaklan
Aug 19, 2019Diamond Contributor
In theory it shall work. Could you share formulas you used, or better the sample?
- madeleine101Aug 19, 2019Copper Contributor
Hi SergeiBaklan
Are you able to see this attachment?
Vessel 1 only is using direct ref, vessel two has the ID and Index(Match.. neither are working as can be seen with the 'test' which should not have a mass in the cell...
- SergeiBaklanAug 19, 2019Diamond Contributor
Yes thank you. If we consider PrimaryTable and Vessel2:
Let add one more row into first one with ID=9
After that add empty row into Vessel2 and enter 9 into ID
It works, Mass is zero since we didn't add it so far.
- madeleine101Aug 19, 2019Copper Contributor
So have you kept the same equation and then manually typed in the ID of the new row into the vessel2 table?