excel vba 多条件查询. 收集一下,以备不时只需。 =VLOOKUP(G2&H2,IF({1,0},A2:A7&C2:C7,B2:B7),2,) =VLOOKUP($G$2&$H$2,CHOOSE({1,2,3},$A$2:$A$7&$C$2:$C$7 ...
確定! 回上一頁