Did they change how contact list and formulas interact?
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?
Answers
-
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.
-
I'll try INDEX and MATCH to see if I get any better luck
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!