Vlookup approximate lookup not working

[maadws]

Description

When vloopup last argument is true it still searches for exact results while in excel it searched for approximate results

Steps to reproduce

1. add a lookup table with first column all numbers in sorted order
2. add vlookup and search for a number inbetween
3. no results
   check demo

Demo

https://codesandbox.io/s/competent-jackson-490o7?file=/src/hyperformulaConfig.js

Your environment

node10.15.3/chrome 92.0.4515.107(64bit)

• HyperFormula version: 1.0.0
• Browser Name and version: chrome 92.0.4515.107(64bit)
• Operating System :windows 10

[maadws]

The problem is related to this line it seems if binary search is used it forces exact matching. to work around it for now I made binarySearchThreshold = 1 in my config (also updated the demo)

[wojciechczerniak]

Done in #791