1.1- =VLOOKUP($F24,$B23:$D36,COLUMN(B1),FALSE)
复制代码 1.2- =VLOOKUP(C47,{1,"金牌";2,"银牌";3,"铜牌";4,"未得奖"},2)
复制代码 2.1- =VLOOKUP(A18,TRANSPOSE($A$12:$G$14),2,)
复制代码 2.2- =VLOOKUP(A18,TRANSPOSE($A$12:$G$14),3,)
复制代码 3- =VLOOKUP(E16&F16,IF({1,0},A16:A27&B16:B27,C16:C27),2,)
复制代码 4.1- =VLOOKUP($F15&" ",$B$14:$D$27,COLUMN(B1),)
复制代码 空格复制B14单元格内容后面的,不显示但可以涂黑的字符
4.2- =VLOOKUP(REPT("0",3-LEN(F19))&F19,$A$14:$D$27,3,)
复制代码 5- =VLOOKUP(E19,IF({0,1},A19:A27,B19:B27),2,)
复制代码- =INDEX(A19:A27,MATCH(E19,B19:B27,))
复制代码- =OFFSET(A18,MATCH(E19,B19:B27,),)
复制代码- =INDIRECT("A"&MAX(IF(B19:B27=E19,ROW(B19:B27))))
复制代码- =LOOKUP(0,0/(E19=B19:B27),A19:A27)
复制代码- =LOOKUP(1,--(B19:B27=E19),A19:A27)
复制代码 |