ªð¦^¦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)

¦^´_ 1# leondavinci727

ªÅ®æªº°ÝÃD¡A¥i¥H¨Ï¥Îtrim¨ç¼Æ¨Ó²¾°£¡A¥t¥~²Ä¤G­Ó°ÝÃD¡A¥Ñ©óµLªk½aÁ|©Ò¦³ªºª¬ªp¡A©Î³\¥i¥H¹Á¸Õ¨Ï¥Îfind¨ç¼Æ§ä¨ìÃöÁä¦r(¸ê²£)¡A¨Ó§PÂ_¬O§_¨Æ§A»Ý­nªº¸ê®Æ¡C

TOP

§A¥i¥H试试这两个¨ç数¤@°_¥ÎINDEX¡BMATCH¡A¦³时®ÄªG¤ñVLOOKUP¦³¦n¡C

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD