Why do I have to index every row from my source sheet on my new sheet?
I am using Index to automatically create a line item on a secondary sheet. It only populates one field on the new sheet, then there are other formulas for the remaining fields. If I do not add every line from my source sheet to my new sheet, when the source sheet has any change to it will result in my new sheet dropping data.
This is a client list and I didn't want all clients on the new sheet. However, if I don't have all rows in the client list accounted for in my new sheet, my new sheet corrupts when a change is made in the client list. In testing through this, I had line 40 in my client list that was not mapped in my new sheet. When I resorted my client list, the client that was listed on line 40 in my new sheet dropped off of the new sheet.
Help Article Resources
Check out the Formula Handbook template!