Formula Error


I have created an INDEX MATCH formula to update the location column in my Headcount sheet that references the Change sheet. It has worked in the first record of the Headcount but when I have dragged it down (to test it works for the next record, before making it a column formula), I get an error. The Employee ID exists on both the Headcount and Changes sheets so, I'm confused at why it works for the first record on the Headcount sheet but not any of the others. I have made the EEEID columns contact types on both the Changes and Headcount columns to retain the zero number prefix.

Anyone that can enlighten me?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!