Did they change how contact list and formulas interact?

Justin Martine

I have a sheet that is mapping the supervisor email from a different sheet using vlookup (I want to keep this formula active in case there are supervisor changes). The format for the supervisor email is contact list. I'm using the supervisor email mapped in a countifs formula that was working last week. Now I'm getting #NO MATCH when nothing has changed. Last week it was working perfectly, suddenly everything is broken.

Anyone else experience this issue?

Joshua Haynes

I haven't had this issue, I've got our sheets set up to use the INDEX and MATCH formula to call in contact information. I did notice when I updated the sheet name it broke everything, I had to reassociate the formulas with the sheet.

Justin Martine

I'll try INDEX and MATCH to see if I get any better luck