½Ð°Ý¤@¤U¡A¦pªG§Ú¨Ï¥Î¤@ÓVLOOKUP¤½¦¡¡A°Ñ·Ó¸ê®Æ¬O¨Ó¦Û©ó¨ä¥L¤À¶
ì¥ý¤½¦¡¦p¤U¡G
=VLOOKUP(A1,'2019¦û¦³²v'!A:Z,2,FALSE)
²{¦b§Ú§Æ±æ°µ¤@ÓB1Ó¬O¥i¥H¿é¤J¦~¥÷¡G2019/2018/2017µ¥
¦Û°ÊÀ°§Ú±aÓ¤À¶ªº¸ê®Æ¶i¨Ó¡AÀ³¸Ón«ç»òקï©O??
§Úªº§@ªk¬O¡G
=VLOOKUP(A1,"'" & B1 & "¦û¦³²v" &"'!A:Z",2,FALSE)
¦ý¬O¤@ª½½Õ«×¤£¥X¥ô¦ó¸ê®Æ¡A½Ð°Ý¬Oþ¸Ìªº°ÝÃD©O?? |