Forum Discussion
XLOOKUP
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.
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.