From f280c03345dc2a207ac319182da182a0f0fbb963 Mon Sep 17 00:00:00 2001
From: Stani <spe.stani.be@gmail.com>
Date: Sat, 21 Aug 2021 05:58:15 +0200
Subject: This closes #997, fix LOOKUP function to find nearest match (#1001)

---
 calc_test.go | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'calc_test.go')

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
-- 
cgit v1.2.1