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 ...
madeleine101 , could you use as ID Code&Material&Dis.Type or so?
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?