How can I get the contact information to update when there are changes to the reference sheet?
I have an Assessment sheet where contacts are auto assigned using a match Match/Index formula. I have updated the reference sheet with a different contact, but that change is not reflecting in the Assessment sheet. Is there an additional step I need to take to get this to refresh?
Help Article Resources
Check out the Formula Handbook template!