=IF(ISERROR(公式),"",公式) =(VLOOKUP("*"&A2&"*",{"00 01 02","对"},2,0))这两个公式如何嵌套

2025-04-04 01:33:21
推荐回答(1个)
回答1:

=IF(ISERROR(VLOOKUP("*"&A2&"*",{"00 01 02","对"},2,)),"",VLOOKUP("*"&A2&"*",{"00 01 02","对"},2,))

=IF(ISNA(MATCH("*"&A2&"*",{"00 01 02"},)),"",VLOOKUP("*"&A2&"*",{"00 01 02","对"},2,))