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

¦³ÃöVLOOKUP·j´M©Î¨ä¥L·j´M¨ç¼Æ

¦³ÃöVLOOKUP·j´M©Î¨ä¥L·j´M¨ç¼Æ

¦p±NAÄæ³]¬°¸ê®Æ®w  A1=¶×¶O
BÄæ¬O­n·j´MªºªF¦è¡AB1=¶×¶O$30
C1³]VLOOKUP¡A¥Ø¼Ð·j´MB1¡A¦bAÄæ·j´M¡A¦pB1¥]§tA1ªº¦r²´¡A´NÅã¥ÜA1¡A¦]B1¥]§tA1ªº¦r²´(¶×¶O)¡A«hÅã¥ÜA1¡A³o³¡¤À¬OVLOOKUP¶Ü?ÁÙ¬O¨ä¥L·j´M¨ç¼Æ¡C
Benson Liu

¥»©«³Ì«á¥Ñ ddtggg ©ó 2018-9-24 19:36 ½s¿è

¦^´_ 1# k8234g


    https://support.office.com/zh-tw/article/%E4%BD%BF%E7%94%A8-vlookup%E3%80%81index-%E6%88%96-match-%E5%B0%8B%E6%89%BE%E5%80%BC-7144ef3f-e322-4f95-9e96-f1d743270438
¤£ª¾¹D¦³¨S¦³²Å¦X§Aªº»Ý¨D¡A½Ð¬Ý³sµ²°Ñ¦ÒINDEX¥[MATCHªº¥Îªk¡C

TOP

C1 =IF(ISERROR(FIND(A1,B1)),"",A1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD