Excel-DNA / Excel-DNA/XFunctions

xlookup return array not functioning correctly

Open
#4 2 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.