implicit intersection operator - advice needed

[JonFairclough]

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?

[#2]

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