xlookup return array not functioning correctly

[6lksdrew]

version 0.2 works perfectly as far as I can tell. except the return array doesn't seem to return an array. so lets say I have xlookup(b2,"another-document!a3:a107,another-documenta!3:e107) it should return all values that match lines a,b,c,d,e if criteria from b2 is matched in a3:a107. it only returns one cell. excel normal functions to return all data points a,b,c,d,e starting in the xlookupcell then proceeding to the right the number of cells needed. therefore if I implement your xlookup I missing data return for cells b,c,d,e. hope that makes since. great work tho

[govert]

Does your version of Excel support Dynamic Arrays yet? (You can check for the =UNIQUE function.) If not, it won't expand the result shape automatically for that reason. I have an ArrayResizer trick that might work for older versions, but have put that in here because my Excel already had Dynamic Arrays before it got XLOOKUP.

…

On Mon, 24 Feb 2020, 18:29 6lksdrew, ***@***.***> wrote: version 0.2 works perfectly as far as I can tell. except the return array doesn't seem to return an array. so lets say I have xlookup(b2,"another-document!a3:a107,another-documenta!3:e107) it should return all values that match lines a,b,c,d,e if criteria from b2 is matched in a3:a107. it only returns one cell. excel normal functions to return all data points a,b,c,d,e starting in the xlookupcell then proceeding to the right the number of cells needed. therefore if I implement your xlookup I missing data return for cells b,c,d,e. hope that makes since. great work tho — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#4?email_source=notifications&email_token=AADFHQY6OSSL6R524BWUYRTREPYVPA5CNFSM4K2LUR4KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IPZCMEQ>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AADFHQZYF72LMN4KJBYGGZDREPYVPANCNFSM4K2LUR4A> .

[Ashutosh-Kukreti]

@govert Can you please provide a .xll for the Dynamic Arrays?