Sep 07 2020 09:46 AM
Sep 07 2020 10:20 AM
XLOOKUP is only available in recent versions of Excel in Microsoft 365, not in Excel 2016.
So you have to avoid the use of XLOOKUP. Use VLOOKUP or a combination of INDEX and MATCH instead.
Sep 07 2020 10:44 AM