implicit intersection operator “@“ - advice needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1184249%22%20slang%3D%22en-US%22%3Eimplicit%20intersection%20operator%20%E2%80%9C%40%E2%80%9C%20-%20advice%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184249%22%20slang%3D%22en-US%22%3E%3CP%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%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1184249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E%40%20implicit%20intersection%20operator%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184271%22%20slang%3D%22en-US%22%3ERe%3A%20implicit%20intersection%20operator%20%E2%80%9C%40%E2%80%9C%20-%20advice%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184271%22%20slang%3D%22en-US%22%3EHi!%20Please%20post%20This%20in%20the%20excel%20forum%20for%20better%20chances%20of%20response%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%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
Hi! Please post This in the excel forum for better chances of response

Adam