excel中类似坐标的选择,求公式答:输入以下公式 =INDEX(Sheet2!$B$2:$E$5,MATCH(A2,Sheet2!$A$2:$A$5,0),MATCH(A1,Sheet2!$B$1:$E$1,0))详见附图同表举例 =INDEX($B$2:$E$5,MATCH(G2,$A$2:$A$5,0),MATCH(G1,$B$1:$E$1,0))
excel中如何精确查找函数?答:OFFSET+MATCH函数:公式=OFFSET(C1,MATCH(A9&B9,A2:A6&B2:B6,0),)INDIRECT+MATCH函数:公式 =INDIRECT("C"&MATCH(A9&B9,A1:A6&B1:B6,0))VLOOKUP+CHOOSE函数:公式 :=VLOOKUP(A9&B9,CHOOSE({1,2},A2:A6&B2:B6,B2:C6),2,0)HLOOKUP+TRANSPOSE+CHOOSE函数:公式=HLOOKUP(A9&B9,TRANSPOSE...