1、vlookup函数
=VLOOKUP(T2,$B$2:$C$6877,2,0)
2、match和index函数
=INDEX($A$1:$C$6877,MATCH(T2,$B$1:$B$6877,0),MATCH($W$1,$A$1:$Q$1,0))
3、match和index函数
=INDEX(A:C,MATCH(W10,C:C,0),MATCH($X$1,$A$1:$Q$1,0))
4、companyId和postionId两个条件查找对应的工资水平
={VLOOKUP(T17&U17,IF({1,0},C1:C7999&L1:L7999,P1:P7999),2,0)}
