=IF(B33,MIN(B33)*LOO
UM(B33)*LOOKUP(MIN(B33),$A$1:$A$10,$C$1:C10),$A$1:$A$10, $D
I'm not sure what you're trying to do here. If I understand correctly, you want to find the value in column D that corresponds to the sum of B33 multiplied by the minimum of B33.
If this is correct, you can use a combination of INDEX and MATCH functions like this:
<code>=INDEX($D$1:D10,MATCH(SUM(B33)*MIN(B33), $A$1: $A10))</code>
AI智能问答网免责声明:
以上内容除特别注明外均来源于网友提问、ChatGPT回答,权益归原著者所有,本站仅作效果演示和欣赏之用;
若以上展示有冒犯或侵害到您,敬请联系我们进行删除处理,谢谢!