xlookup return array not functioning correctly
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 28/100
Research direction
Start by reproducing the reported XLOOKUP case in Excel using the example in the issue, then locate the C# implementation of XLOOKUP and inspect how its return array is handled. Done means a match returns all requested values across adjacent cells, rather than only the first value.
Written by the indexing model from the issue text.
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
- Dominant language
- C#
- Stars
- 48
- Forks
- 24
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Excel-DNA/XFunctions
-
last to firstOpen
Difficulty 4/5 3-5 days Newbie friendliness 20/100
Excel-DNA/XFunctions#13 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#10 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#9 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#8 · 5 comments ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Excel-DNA/XFunctions#7 · 1 comment ·
All issues in Excel-DNA/XFunctions
Similar issues
-
[誤判定] `define` が `デフィね`・`デフィ値` になるPossibly taken A pull request linked to this issue is open or already merged. Open再現済み 要トリアージ 誤判定
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
yksr-melt/Meltype#421 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 64/100
Facepunch/sbox-public#12063 · 1 comment ·
Maintainers usually reply within 2 days
-
documentation
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
facioquo/stock-indicators-dotnet#2316 · 1 comment ·
Maintainers usually reply within 1 day
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
ionide/FsAutoComplete#1559 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
lostindark/DriverStoreExplorer#477 ·
Maintainers usually reply within 1 day