如果我们正在谈论Excel 2010及更高版本，则可以使用IFERROR:

If we're talking about Excel 2010 and later you can use IFERROR:

=IFERROR(VLOOKUP(B19:B36;$TABLE.A1:C46;2;0);"")

您还可以将文本放入最终的字符串结果中

You can also put text into the final string result