XLOOKUP - don't take the bait!

%3CLINGO-SUB%20id%3D%22lingo-sub-1776389%22%20slang%3D%22en-US%22%3EXLOOKUP%20-%20don't%20take%20the%20bait!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776389%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20in%20Excel%20under%20Office%20365%20and%20try%20to%20get%20help%20using%20functions%20HLookup%20and%20VLookup%2C%20you'll%20be%20guided%20by%20Microsoft%20to%20use%20the%20new%20and%20improved%20%22XLOOKUP%22%2C%20which%20according%20to%20MS%20replaces%20the%20other%20two.%26nbsp%3B%20DON'T%20DO%20IT!%26nbsp%3B%20%26nbsp%3BMicrosoft%20fails%20to%20warn%20that%20XLOOKUP%20is%20available%20ONLY%20in%20Office%20365%20and%20your%20sheet%20will%20crash%20if%20any%20user%20with%20a%20freestanding%20version%20of%20Excel%20(even%202019)%20tries%20to%20use%20it.%26nbsp%3B%20What%20good%20is%20a%20function%20that%20can't%20work%20in%20any%20other%20version%3F%3F%26nbsp%3B%20This%20has%20been%20pointed%20out%20to%20Microsoft%20in%20forums%20going%20back%20at%20least%20a%20year%2C%20yet%20they%20still%20make%20no%20mention%20of%20this%20issue%20in%20the%20help%20for%20these%20functions.%26nbsp%3B%20It%20cost%20me%20two%20hours%20of%20rebuilding%20spreadsheets%20that%20could%20have%20been%20avoided%20if%20Microsoft%20would%20just%20have%20warned%2C%20or%20better%20yet%2C%20disabled%20the%20feature%20given%20its%20incompatibility.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1776389%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECompatibility%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20-%20Excel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

If you are in Excel under Office 365 and try to get help using functions HLookup and VLookup, you'll be guided by Microsoft to use the new and improved "XLOOKUP", which according to MS replaces the other two.  DON'T DO IT!   Microsoft fails to warn that XLOOKUP is available ONLY in Office 365 and your sheet will crash if any user with a freestanding version of Excel (even 2019) tries to use it.  What good is a function that can't work in any other version??  This has been pointed out to Microsoft in forums going back at least a year, yet they still make no mention of this issue in the help for these functions.  It cost me two hours of rebuilding spreadsheets that could have been avoided if Microsoft would just have warned, or better yet, disabled the feature given its incompatibility.  

0 Replies