[Bug] If there is an invalid value in the vlookup formula, #name is reported?

[zhaolixin7]

在您提交此问题之前，您是否检查了以下内容？

• [X] 这真的是个问题吗？
• [X] 我已经在 Github Issues 中搜索过了，但没有找到类似的问题。

受影响的包和版本

dev

复现链接

1、单元格中公式=VLOOKUP($L6,$h1:h,1)

预期行为

excel

实际行为

运行环境

No response

系统信息

No response

[univer-bot[bot]]

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

Origin Title: [Bug] vlookup公式中有无效值报#name?

Title: [Bug] If there is an invalid value in the vlookup formula, #name is reported?

---

Before you submitted this question, did you check the following?

• [X] Is this really a problem?
• [X] I've searched Github Issues but haven't found any similar issues.

Affected packages and versions

dev

Recurrence link

1. The formula in the cell =VLOOKUP($L6,$h1:h,1)

Expected behavior

excel

Actual behavior

Running environment

No response

system message

No response