first argument of VLOOKUP is not coerced from null

[izulin]

Description

If first argument of VLOOKUP is null, it should be coerced to 0.

it('should coerce empty arg to 0', () => {
  const engine = builder([
    ['0', 'a'],
    ['2', 'b'],
    ['3', 'c'],
    ['4', 'd'],
    ['5', 'e'],
    ['=VLOOKUP(C3, A1:B5, 2)'],
  ])
  expect(engine.getCellValue(adr('A6'))).toEqual('a')
})

Steps to reproduce

Demo

Your environment

• HyperFormula version:
• Browser Name and version:
• Operating System:

Links

[voodoo11]

Fixed in #520

[wojciechczerniak]

Awesome 🏆 Thanks