|
楼主 |
发表于 2024-10-12 15:22
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
IF(OR(_xlfn.MAP($N$4:$N$37,$P$4:$P$37,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,AND(MEDIAN(_xlpm.x,_xlpm.y,B4)=B4,MEDIAN(_xlpm.x,_xlpm.y,D4)=D4)))),"",IF(K3=D3,K3,IFNA(VLOOKUP(LOOKUP(9^9,K$3:K3),$N$4:$P$37,3,),0)))
改成
IF(OR(_xlfn.MAP(强制断开范围!$A$2:$A$40,强制断开范围!$C$2:$C$40,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,AND(MEDIAN(_xlpm.x,_xlpm.y,B4)=B4,MEDIAN(_xlpm.x,_xlpm.y,D4)=D4)))),"",IF(K3=D3,K3,IFNA(VLOOKUP(LOOKUP(9^9,K$3:K3),强制断开范围!$A$2:$A$40,3,),0)))
显示结果成这样了?麻烦看看是怎么回事
|
|