-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
LOOKUP does not handle Array form correctly #994
Comments
I've prepared a pull request #996 against the master branch to fix this issue. How will this land in the v2 branch, which I use? |
xuri
added a commit
to stanim/excelize
that referenced
this issue
Aug 19, 2021
xuri
pushed a commit
that referenced
this issue
Aug 19, 2021
jenbonzhang
pushed a commit
to jenbonzhang/excelize
that referenced
this issue
Oct 22, 2023
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Description
There are two ways to use LOOKUP: Vector form and Array form. For more info, see https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb
Excelize seems to support both, but the Array form does not work as expected. It returns the lookup value instead of the result
Steps to reproduce the issue:
I've done this in my lookup-array-from branch: https://github.com/stanim/excelize/blob/lookup-array-form/calc_test.go#L1135
go test
.Describe the results you received:
Describe the results you expected:
I expected the tests to pass.
Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.):
The text was updated successfully, but these errors were encountered: