Forum Discussion
Xlookup
Hi, i am using Xlookup formula and sending the file to excel 2016 user, and he is getting "#NAME?" error in the formula section how to overcome it.
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.