Excel-DNA / Excel-DNA/XFunctions

xlookup add in doesn't work properly

Open
#8 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
48
Forks
24
PR merge metrics
No merged PRs in 30d

Description

Hi
I have add in ExcelDna.xfunction version 5. only very basic function is working like use it as vlookup, most the function doesn't work
![image](https://user-images.githubusercontent.com/92610955/137564588-7a25c743-a4b4-4e35-95d5-4ecdae7256e1.png)
for example if my lookup value is single cell, it's working. if my lookup value is multi cells, it doesn't work
![image](https://user-images.githubusercontent.com/92610955/137564727-a44e7c67-feb4-4a93-a3ec-61149b5be266.png)
Also if i want to use more complicated xlookup function like search the next smaller value, it doesn't work via single cell or multi cells
![image](https://user-images.githubusercontent.com/92610955/137564843-a9a230cd-66cd-471b-acb4-705e426a0fdb.png)

I use microsoft 2019, I install for 64
![image](https://user-images.githubusercontent.com/92610955/137564947-7fbfb69b-b43c-47bf-bf65-c196a37b6e39.png)

please advise it

Thanks
Vivien

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.