govert
commented
4 years ago 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, notifications@github.com 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 https://github.com/Excel-DNA/XFunctions/issues/4?email_source=notifications&email_token=AADFHQY6OSSL6R524BWUYRTREPYVPA5CNFSM4K2LUR4KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IPZCMEQ, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADFHQZYF72LMN4KJBYGGZDREPYVPANCNFSM4K2LUR4A .
Ashutosh-Kukreti
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