ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VLOOKUP °Ñ·Ó¥i§_±aÅܼÆ

[µo°Ý] VLOOKUP °Ñ·Ó¥i§_±aÅܼÆ

½Ð°Ý¤@¤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??

¦^´_ 1# lichang

¸Õ¸Õ¬Ý
=VLOOKUP(A1,INDIRECT(B1&"¦û¦³²v"&"!A:Z"),2,FALSE)

TOP

¦^´_ 2# jcchiang


    ÁÂÁ§A¡A¥i¥H¤F¡A·PÁ§A³á!!!

¥i¥H°Ý¤@¤U¡A¬°¤°»ò¤@©w­n¥ÎINDIRECT¶Ü??

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD