=VLOOKUP($E2&"x"&$F2,IF(COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6),
=VLOOKUP($E2&"x"&$F2,IF(COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6),$A$2:$A$6&"x"&$B$2:$B$6,$C$2:$C$6),2,0)
为什么COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6)=（1,0）还有$A$2:$A$6&"x"&$B$2:$B$6,$C$2:$C$6)代表什么意思,还有IF(COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6),$A$2:$A$6&"x"&$B$2:$B$6,$C$2:$C$6)是什么意思,
为什么COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6)=（1,0）还有$A$2:$A$6&"x"&$B$2:$B$6,$C$2:$C$6)代表什么意思,还有IF(COLUMN($A$2:$B$6)=COLUMN($A$2:$A$6),$A$2:$A$6&"x"&$B$2:$B$6,$C$2:$C$6)是什么意思,
赞
可能相似的问题