【原】学会这个无敌的函数套路,90%的Excel查找问题都能轻松解决!
=LOOKUP(1,0/(C2:I2<=0),C1:I1)
=LOOKUP(1,0/(查找区域=查找值),返回区域)
=MATCH(1,0/(C2:I2<=0))
=INDEX(C1:I1,MATCH(1,0/(C2:I2<=0)))
=INDEX(C1:I1,MATCH(0,0/(C2:I2<=0),0))
=XLOOKUP(0,0/(C2:I2<=0),C1:I1)
=TEXTJOIN(",",1,IF(C2:I2<=0,C1:I1,""))
=SUMPRODUCT((C2:I2<0)*C2:I2)
这个套路如果研究透了,能够随意变形,绝大多数的查找问题都可以解决。
你还知道什么厉害的函数套路?