【原】學會這個無敵的函數套路,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)
這個套路如果研究透了,能夠隨意變形,絕大多數的查找問題都可以解決。
你還知道什麼厲害的函數套路?