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

[µo°Ý] ¦h­ÓÄæ¦ì¬d§ä¡H

[µo°Ý] ¦h­ÓÄæ¦ì¬d§ä¡H

¸ê®Æ¨Ó·½¦p¤U¹Ï¡A
¦³¨â­Ó³¡¥÷¡A¢é¡Ð¢êÄæ¡B¢ì¡Ð¢íÄæ
¨ä¤¤¼Æ¦rªº³¡¥÷¡A¤£¤@©w·|¨ì¢²¢°¡A
¥B¢éÄæ¤]¤£¤@©w·|¨ì¢°¢´¡A¤]¦³¥i¯à¬O¢±¢¯©Î¬O¢°¢¯¡A
¢ìÄæ¤]¤£¤@©w·|±q¢°¢µ¶}©l¡C
test 2.jpg
2021-5-21 22:35


½Ð°Ý¸Ó¦p¦ó³]¤½¡AÅý¤u§@ªí¢°¥i±a¤J¤u§@ªí¢±ªº¸ê®Æ¡H
¥»¥H¬°¥i¥H¥Î¢ñ¢î¥h¶]¡Aµo²{·Q±o¤Ó²³æ¤F¡C
test 1.png
2021-5-21 22:35


½Ð°Ý¦³¤èªk¥i¥H¬d§ä¤u§@ªí¢±ªº¸ê®Æ¨ì¤u§@ªí¢°¶Ü¡H

ÁÂÁÂ

test.zip (9.16 KB)

¦^´_ 1# mikan


½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
  
=IFERROR(VLOOKUP(A2,¤u§@ªí2!A:B,2,0),VLOOKUP(A2,¤u§@ªí2!D:F,3,0))

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# samwang

¦^´_ 3# hcm19522


ÁÂÁ¨â¦ì¡A´ú¸Õok:)

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD