diff options
| author | Stani <spe.stani.be@gmail.com> | 2021-08-21 05:58:15 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-21 11:58:15 +0800 |
| commit | f280c03345dc2a207ac319182da182a0f0fbb963 (patch) | |
| tree | 4539abcb3d681762ae34726942b78dee9d144856 /calc_test.go | |
| parent | 935af2e356ff60c88761db1fc9a6be8f8c67a4f5 (diff) | |
This closes #997, fix LOOKUP function to find nearest match (#1001)
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 7c107f3..8deab93 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1151,6 +1151,8 @@ func TestCalcCellValue(t *testing.T) { "=LOOKUP(F8,F8:F9,D8:D9)": "Feb", "=LOOKUP(E3,E2:E5,F2:F5)": "22100", "=LOOKUP(E3,E2:F5)": "22100", + "=LOOKUP(F3+1,F3:F4,F3:F4)": "22100", + "=LOOKUP(F4+1,F3:F4,F3:F4)": "53321", "=LOOKUP(1,MUNIT(1))": "1", "=LOOKUP(1,MUNIT(1),MUNIT(1))": "1", // ROW |