[Bug] issue from Logical functions

[Dushusir]

Before you submit this issue, have you checked the following

• [X] Is this really a problem?
• [X] I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

latest

Reproduction link

1、公式计算结果错误（）

分析：VLOOKUP 查找算法

2、修改引用选区后undo，公式未显示计算结果2024_7_8 10_58_16 commands.json 2024_7_8 10_58_16 video.webm 分析：数据更新问题

3、引用选区为空计算不出结果，Excel、365支持 分析：为空是大多数函数通用问题，很多没有处理，需要统一处理

Expected behavior

匹配Excel

Actual behavior

查找不对

System information

No response

[univer-bot[bot]]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: [Bug] issue from Logical functions

Title: [Bug] issue from Logical functions

---

Before you submit this issue, have you checked the following

• [X] Is this really a problem?
• [X] I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

latest

Reproduction link

1. The formula calculation result is wrong ()

Analysis: VLOOKUP lookup algorithm

2. After modifying the reference selection and undoing it, the formula does not display the calculation result 2024_7_8 10_58_16 commands.json 2024_7_8 10_58_16 video.webm Analysis: Data update issues

3. If the reference selection is empty, no result can be calculated. Excel and 365 support it. Analysis: Nullity is a common problem for most functions, many of which are not handled and need to be handled uniformly.

Expected behavior

Match Excel

Actual behavior

Wrong search

System information

No response