|
第一题:1. A4=D4 , A7=INDIRECT(A4) ;<br/> 2. A5=R4C4 ,A8=INDIRECT(INDIRECT("r5c1",),) ; <br/> 3. A10=INDIRECT(“D4”) ; <br/> 4. A11=INDIRECT("R4C4",0) ;<br/> 第二题:=INDIRECT("r"&MATCH(A24,A:A,0)&"c5",) ;<br/> 第三题:=IF(ISNA(VLOOKUP(RC[-1],INDIRECT("'"&RC[-2]&"'!A:B"),2,0)),"",VLOOKUP(RC[-1],INDIRECT("'"&RC[-2]&"'!A:B"),2,0))<br/> |
|