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

[µo°Ý] ½Ð±ÐÃö©óVLOOKUPªº°ÝÃD¡C

[µo°Ý] ½Ð±ÐÃö©óVLOOKUPªº°ÝÃD¡C

±z¦n
§Ú±qºô¯¸¤W½Æ»s°]³ø¸ê®Æ¡A¥H­Ó§Oªº¤À­¶¦s©ñ¡A¦p¤À­¶ "104-01"¡B"103-01"¡A·Q²³æ§Q¥ÎVLOOKUP¨ç¼Æ¡A´M§ä¦U³æ¤@¤À­¶¤ºªº¬Y¨Ç·|­p¦WºÙ¡A±a¤J¦¹¶µ¥Ø¥kÃä¤@Ä檺¼Æ¦r¸ê®Æ¦b "¤ñ²v" ³o­Ó¤À­¶¡A±q¦Ó²³æ­pºâ¤@¨Ç¤ñ²v¡A ¹J¨ìªº°ÝÃD¬O ¥Ø¼ÐÄ榳ªÅ®æ¡A¯à§_²³æ±Æ°£³o­Ó»Ùê¡A¦Ó¤£»Ý­n¦A¦b¨C­Ó ¸ê®Æ¤À­¶¥h§@®ø°£Äæ¦ìªÅ®æªº°Ê§@¡A¦¸¤@­Ó°ÝÃD¬O¡A¬Y¨Ç¸ê®Æ¤ºªº·|­p¦WºÙ²¤¦³¤£¦P¡A¤£ª¾¦p¦ó§@Ãþ¦ü©ó IF ªº´M§ä¡A±q¦Ó±a¥X¥kÃä¤@Ä檺¸ê®Æ¡C
·PÁ±zªº¼·¨I½ç±Ð¡I
2498 §»¹F¹q.rar (119.37 KB)

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD