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

[µo°Ý] Vlookup«ç°µ½Æ¦XÀ³¥Î

¦^´_ 1# keny1021
´£¨Ñ¤U¦C¤èªk¡A½Ð°Ñ¦Ò¡I
Step_1¡G©ó¡u´M§ä­È¡v¤u§@ªí¤§C2Àx¦s®æ¿é¤J
=INDEX(DATA!$C:$C,MATCH(´M§ä­È!$A$2&B2,DATA!A:A&DATA!B:B,0))
Step_2¡GÄò¥HCtrl+Shift+Enter§¹¦¨²Õ¦X¤½¦¡(°}¦Cªk)
Step_3¡G¦V¤U½Æ»s¤½¦¡§Y¥i

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD