One of the advantages of XLOOKUP is that the return value can be a range from within a bigger range. Lox365 version of XLOOKUP works just fine when I need it to return a row corresponding to the matched value, but I cannot find out why it does not work with columns.
Is it possible to do this in lox365 XLOOKUP? If so, what am I doing wrong?
Or maybe this is a bug or the implementation is not the same as in Excel?
I know it does not support search_mode and match_mode, but returning column should be possible. Here is a file where I demonstrate the problem:
lox365-xlookup-not-working-for-columns.ods (14.3 KB)