2.关联匹配函数

1.
=VLOOKUP(B2,Sheet1!A:B,2,FALSE)
2.
=INDEX(Q2:T11,2,2)
=MATCH(6,R2:R12,0)或者=MATCH(R2,R2:R12,0)
=INDEX(S2:T7,MATCH(S2,S2:S7,0),1)
3.
=ROW()
=RIGHT(A1,1)
=RIGHT(A2,1)
再做筛选
4.
=OFFSET(U2,1,1,1,1)
5.
=HYPERLINK(V24)