diff options
| author | Stani <spe.stani.be@gmail.com> | 2021-08-19 16:12:37 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-19 22:12:37 +0800 |
| commit | dca03c6230e596560ea58ca1edb27581cdd59aaa (patch) | |
| tree | c8cecc564f4210751a2792c7f4c324da912cc8bf /calc_test.go | |
| parent | a55f354eb3d0c6c1b9a543ff8ff98227aa6063a6 (diff) | |
This closes #994, fix LOOKUP function for Array form
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 54bdc01..ffcdb4d 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1131,6 +1131,9 @@ func TestCalcCellValue(t *testing.T) { // LOOKUP "=LOOKUP(F8,F8:F9,F8:F9)": "32080", "=LOOKUP(F8,F8:F9,D8:D9)": "Feb", + "=LOOKUP(E3,E2:E5,F2:F5)": "22100", + "=LOOKUP(E3,E2:F5)": "22100", + "=LOOKUP(1,MUNIT(1))": "1", "=LOOKUP(1,MUNIT(1),MUNIT(1))": "1", // ROW "=ROW()": "1", @@ -2090,6 +2093,7 @@ func TestCalcCellValue(t *testing.T) { "=LOOKUP()": "LOOKUP requires at least 2 arguments", "=LOOKUP(D2,D1,D2)": "LOOKUP requires second argument of table array", "=LOOKUP(D2,D1,D2,FALSE)": "LOOKUP requires at most 3 arguments", + "=LOOKUP(1,MUNIT(0))": "LOOKUP requires not empty range as second argument", "=LOOKUP(D1,MUNIT(1),MUNIT(1))": "LOOKUP no result found", // ROW "=ROW(1,2)": "ROW requires at most 1 argument", |