Sheet2!$A$2:$A$12&Sheet2!$B$2:$B$12,Sheet2!$C$2:$C$12,这一段情各位大侠们帮小弟解释一下究竟是啥意思
相似回答
{=VLOOKUP(A2 &B2,IF({1,0},Sheet2!$A$2:$A$12 &Sheet2!$B$2:$B...答:$A$2:$A$12=A2)*(Sheet2!$B$2:$B$12=B2)),Sheet2!$C$2:$C$12)用这个公式,试试看{=VLOOKUP(A2 &B2,IF({1,0},Sheet2!$A$2:$A$12 &Sheet2!$B$2:$B$12,Sheet2!$C$2:$C$12),2,FALSE...