Xlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-1642042%22%20slang%3D%22en-US%22%3EXlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642042%22%20slang%3D%22en-US%22%3EHi%2C%20i%20am%20using%20Xlookup%20formula%20and%20sending%20the%20file%20to%20excel%202016%20user%2C%20and%20he%20is%20getting%20%22%23NAME%3F%22%20error%20in%20the%20formula%20section%20how%20to%20overcome%20it.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1642042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1642095%22%20slang%3D%22en-US%22%3ERe%3A%20Xlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767899%22%20target%3D%22_blank%22%3E%40SubhasisB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EXLOOKUP%20is%20only%20available%20in%20recent%20versions%20of%20Excel%20in%20Microsoft%20365%2C%20not%20in%20Excel%202016.%3C%2FP%3E%0A%3CP%3ESo%20you%20have%20to%20avoid%20the%20use%20of%20XLOOKUP.%20Use%20VLOOKUP%20or%20a%20combination%20of%20INDEX%20and%20MATCH%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1642105%22%20slang%3D%22en-US%22%3ERe%3A%20Xlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642105%22%20slang%3D%22en-US%22%3EHello%2C%20as%20hans%20rightly%20replied%2C%20XLOOKUP%20and%20all%20Dynamic%20Array%20functions%20are%20available%20in%20Excel%20for%20Microsoft%20365.%20So%2C%20if%20you%20opened%20a%20workbook%20that%20contains%20any%20of%20these%20functions%20in%20order%20versions%2C%20I%20will%20result%20name%20%23Name%3F%20error...%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20you%20can%20save%20the%20file%20in%20One%20Drive%20and%20when%20another%20person%20access%20the%20file%20on%20Excel%20on%20the%20web%2C%20they%20will%20be%20able%20to%20relate%20with%20the%20data%20because%20XLOOKUP%20and%20Dynamic%20Arrays%20are%20all%20available%20on%20the%20web.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
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.
2 Replies
Highlighted

@SubhasisB 

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.

Highlighted
Hello, as hans rightly replied, XLOOKUP and all Dynamic Array functions are available in Excel for Microsoft 365. So, if you opened a workbook that contains any of these functions in order versions, I will result name #Name? error...

However, you can save the file in One Drive and when another person access the file on Excel on the web, they will be able to relate with the data because XLOOKUP and Dynamic Arrays are all available on the web.

Cheers