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...