<p>1.A4=D4 A5=r4c4</p><p>=INDIRECT(A4)</p><p>=INDIRECT(A5,0)</p><p>=INDIRECT("D4")</p><p>=INDIRECT("r4c4",0)</p><p>2.=INDIRECT("r"&MATCH(A24,A18:A21,0)+ROW(A17)&"c"&MATCH(B23,A17:F17,0),0)</p><p>3.=IF(ISNA(VLOOKUP(B37,INDIRECT("'"&A37&"'!A:B"),2,0)),"",VLOOKUP(B37,INDIRECT("'"&A37&"'!A:B"),2,0))</p> |