¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-8-25 16:17 ½s¿è
¤S·Q½Ðª©¥DÌÀ°À°¤F,¥H¤U¤@±ø¤½¦¡¦p¦ó±N "01" ´«¦¨°Ñ·Ó RC[-1] ?
'=INDIRECT('01'!R47C" & MATCH(RC[-2],'01'!R2,0),FALSE)''''''''''''''''''ok,¥i¥H¥Î
§â²Ä¤@Ó '01' ´«¦¨°Ñ·Ó RC[-1],Åܦ¨
'=INDIRECT(RC[-1]&"!R47C" & MATCH(RC[-2],'01'!R2,0),FALSE)''''''¤]ok,¥i¥H¥Î
¦ý§Ú§â²Ä¤GÓ '01'¤]´«¦¨°Ñ·Ó RC[-1],Åܦ¨
=INDIRECT(RC[-1]&"!R47C" & MATCH(RC[-2],RC[-1]&"!R2",0),FALSE)''''''¤£¯à¥Î!!!
§Ún¦bsheets("01")¨½§ä¥X R47C3,¦ý¨ä¤¤ªº"3"n¾a match ¦bsheets("01")ªº²Ä2¦C¨½§ä¨ì¦ì¸m¤~±o¨ì²Ä3Äæ
À°¥DÌ,¨D±Ï¤F,ÁÂÁ |