How do I fix my Misaligned rows in My master spreadsheet to the reference sheet?

Question

I have a case assignment master spreadsheet set up for work, and each employee then has their own individual worksheet in the same workbook. Each row on the employee's sheet has an "IF" formula referencing the same row on the master spreadsheet. Until recently it has duplicated fine, but now for example it shows the row number to be 2 more than it is on the master spreadsheet. For example, row A5987 is being pulled from the master spreadsheet and placed on row A5989 on the employee's sheet. There are no hidden rows and the formula hasn't changed. It didn't change until row A5958 and everything after that is off by 2 now.

Answer 1

Hello Bryana Harrah

Thank you for posting on Microsoft Q&A forum

I will need you to confirm the root cause of this misalignment:

Go to row 5956–5960 on both sheets

Right‑click > Insert a row on BOTH sheets at the same position

See if the offset:

• stays +2 > structural mismatch exists
• disappears > rows were previously misaligned

Also, can you provide the formula you use on the employee sheet with the IF formula?

Knowing this information can help me better understand you issue and come up with suitable solution to help you.

Feel free reply back to this post and update me on the situation, I'll continue to help you.