Index Match is pulling correctly and then starts duplicating wrong values in cell

edited 03/18/24 in Formulas and Functions

Hello, I am trying to pull in the email address from a master contact list into a different contact list with pay rates. I am using this formula: =INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME})) and initially it is pulling the correct email address to the correct individual, then further down the page it starts duplicating the same persons email address for the incorrect name and I can't figure out why.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!