Forum Discussion

Man Fai Chan's avatar
Man Fai Chan
Iron Contributor
Apr 02, 2020
Solved

XLOOKUP

I heard a new function XLOOKUP which is very powerful and replace the function of VLOOKUP.    It works find at my home computer installing Office 365, but it cannot be recognized as a function in m...
Formulas and Functions
  • gyankosh's avatar
    gyankosh
    Apr 02, 2020

    Yes absolutely, the XLOOKUP function is fantastic. It handles a lot of things in a single shot. e.g. the ability to return a complete set of array, no enforcing of comparing the leftmost column only etc. Yes it is only presently given in office 365 and excel for android. Many users of office 365 had to wait to get this function, not all were provided.  It seems like it was given for a test kind of thing.

    In future , it is expected that it becomes a standard formula of all excel versions through updates. For time being if you are just interested , you can have a look at it here

    https://gyankosh.net/msexcel/functions/office365/excel-function-xlookup/#gsc.tab=0 

    Still you have to use VLOOKUP  or INDEX MATCH only as its not available. But I hope that it get available through an update in near future.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 02, 2020

Man Fai Chan 

I don't think it'll be on Excel 2019, perhaps on Excel 2022 or so.

All power of XLOOKUP is if using on dynamic arrays Excel. Otherwise yes, that's nice to have, but INDEX/MATCH provides practically the same functionality.  

Resources