Using Index to create sheet values
I am using Index to create new sheet values. I am finding that I cannot add rows to the new sheet that do not use the Index function and still have the sheet function properly. If I add rows with no Index, when the source sheet for the Index is changed, the new sheet will have data changed and removed incorrectly.
Help Article Resources
Check out the Formula Handbook template!