implicit intersection operator - advice needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1184393%22%20slang%3D%22en-US%22%3Eimplicit%20intersection%20operator%20-%20advice%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20use%20Excel%20365%2C%20and%20recently%20it%20has%20been%20adding%20the%20implicit%20intersection%20operator%20%E2%80%9C%40%E2%80%9C%20in%20front%20of%20some%20functions%2C%20including%20INDEX%2C%20MATCH%20and%20IF.%20Some%20colleagues%20and%20customers%20still%20use%20Excel%202016%2C%20and%20my%20workbooks%20now%20don%E2%80%99t%20work%20for%20them.%20They%20get%20%23NAME!%20errors.%20What%20should%20we%20do%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1184393%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184426%22%20slang%3D%22en-US%22%3ERe%3A%20implicit%20intersection%20operator%20-%20advice%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184426%22%20slang%3D%22en-US%22%3EThis%20should%20work.%20Can%20you%20please%20share%20an%20anonymized%20workbook%20which%20demonstrates%20the%20issue%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I use Excel 365, and recently it has been adding the implicit intersection operator “@“ in front of some functions, including INDEX, MATCH and IF. Some colleagues and customers still use Excel 2016, and my workbooks now don’t work for them. They get #NAME! errors. What should we do?

1 Reply
Highlighted
This should work. Can you please share an anonymized workbook which demonstrates the issue?