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

[µo°Ý] ½Ð°Ý¯à§_±a¥X¨ä¥LÄæ¦ì¸ê®Æ

[µo°Ý] ½Ð°Ý¯à§_±a¥X¨ä¥LÄæ¦ì¸ê®Æ

±ÄÁʲM³æ.rar (80.4 KB)

½Ð±Ðª©¤Wªº°ª¤â¡A¯à§_¦b¤u§@ªíSheet1ªº"«~¦W"¤U¤èÄæ¦ì¡A±a¥X¸ê®Æ1.¸ê®Æ2.¸ê®Æ3¤u§@ªí¸Ìªº«~¦W¤º®e?ÁÂÁÂ

¦^´_ 1# mrcv3
©óA6Àx¦s®æ¿é¤J
=IFERROR(VLOOKUP($B6,¸ê®Æ1!$A:$B,COLUMNS($A$5:B$5),FALSE),IFERROR(VLOOKUP($B6,¸ê®Æ2!$A:$B,COLUMNS($A$5:B$5),FALSE),VLOOKUP($B6,¸ê®Æ3!$A:$B,COLUMNS($A$5:B$5),FALSE)))
¤§«á©¹¤U½Æ»s§Y¥i¡A½Ð°Ñ¦Ò¡C

TOP

¦^´_ 1# mrcv3


    A6=VLOOKUP(B6,INDIRECT("'"&LOOKUP(2,1/(C6:E6<>""),$C$4:$E$4)&"'!A:D"),2,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¦U¦ì°ª¤âªº¸Ñµª¡A·P®¦~~

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD