函数公式错不知道在哪里？

zhangyn3392477 · 发表于 2022-4-7 22:09

各位大神：
表格中的函数公式错不知道在哪里？哪位高手能帮忙解决一下吗？谢谢！

niko88819 · 发表于 2022-4-8 06:51

B2

=IF($A2="","",INDEX({"68952","14930","49386","73291","60249","87956","13579","60249","13579","20134","60249","68952","40268","87956","38271","04913","75139","90436","75139","49036","14930","51379","57340","04913","12357","84796","91357","14930","42068","69034","02784","27568","40268","68952","49021","13247","91357","27135","27568","40268","59627","82496","52713","02134"},MATCH($A2,{"5-1-8","0-8-8","6-0-1","2-4-1","2-7-5","9-4-4","1-8-4","0-7-4","5-8-4","2-9-9","6-7-4","9-1-8","0-9-5","5-4-4","1-5-1","0-8-4","5-8-5","6-7-1","5-8-9","6-7-9","2-8-8","1-6-5","5-1-1","2-8-4","1-9-1","0-0-1","5-8-1","1-8-8","0-9-9","6-2-1","0-9-1","9-9-1","0-9-1","6-1-8","2-8-1","5-6-1","9-8-3","3-8-1","9-9-9","6-9-3","9-4-1","9-3-1","1-6-9","2-7-1"},)))

复制代码

zhangyn3392477 · 发表于 2022-4-8 09:50

niko88819 发表于 2022-4-8 06:51
B2

问题解决了，感谢尼可师妹，谢谢你帮了大忙。

37廿一 · 发表于 2022-4-8 10:18

2个0-9-1？

		自动登录	找回密码
密码			免费注册

[求助] 函数公式错不知道在哪里？