Excel-DNA / Excel-DNA/XFunctions
xlookup return array not functioning correctly
- Dominant language
- C#
- Stars
- 48
- Forks
- 24
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.