Forum Discussion
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 ...
I tried using an ID code for the whole table, also tried splitting the table into two and using ID codes for both but neither seem to work as when a row is added, the cells still do not sync or jump correctly...
Did you try VLOOKUP or INDEX/MATCH on this combined ID? Perhaps you may attach sample file removing all sensitive information to play with it.
In theory it shall work. Could you share formulas you used, or better the sample?
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...