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

¸ê®Æ§t¼Æ¦r¤Î­^¤å¦p¦óÅý¹q¸£¥ÎVLOOKUP¨ç¼Æ¤ÀªR?

¸ê®Æ§t¼Æ¦r¤Î­^¤å¦p¦óÅý¹q¸£¥ÎVLOOKUP¨ç¼Æ¤ÀªR?

§Ú±qACCESS¶×¤J¸ê®Æ¨ìEXCEL
¨ä¤¤¦³¤@Äæ¦ì¬O­^¼Æ¦r²V¦X¡A¦p
1139
2200
B700
K991

¦]§Ú­n¥ÎVLOOKUP¨ç¼Æ®»¨ú¹ï¬M¸ê®Æ¡A¦p
1139  ±i¤T
2200  §õ¥|
B700  ¤ý¤­
K991  »¯¤»

¦ý¥ÎVLOOKUP¨ç¼Æ­n´N¥uÅã¥Ü
1139  ±i¤T
2200  §õ¥|
¤£µM´NÅã¥Ü
B700  ¤ý¤­
K991  »¯¤»

¦³¨S¦³¿ìªk¥þ³¡Åã¥Ü??
¥Î³]©w¬°¤å¦r¤]¨S¥Î¡A³]¼Æ¦r¤]¨S¥Î¡AACCESS¸ê®Æ®w¤£¯à°Ê®@!

³oÀ³¸Ó»P³]¸m¤å¦r©Î¼Æ¦rµLÃö
¥D­n¬Olookup_value»P°Ñ·Óªºtable_array¤£¤@­P¡A¤~·|§ä¤£¨ì

TOP

¨º­n¦p¦ó­×§ï¸ê®Æ©O?

TOP

§â¤£¤@­Pªº¦a¤è­×§ï¦¨¤@­P
¬Ý¤£¨ì§Aªº¤å¥ó¡AÀ³¸Ó¨S¤H¥i¥H¦^µª§A­n¦p¦ó­×§ï¸ê®Æ

TOP

1.±N¾É¤JexcelªºaÄæ>¸ê®Æ>­åªR>¤@¯ë,¦¨¬°³q¥Î®æ¦¡
2.vlookup(a1,...),a1ªºaÄæ¤]­åªR¬°¤@¯ë
®æ¦¡¤@­P«áÀ³¸Ó¥i¦æ

¦p­ì¸ê®Æ¤£¯à°Ê
¨º³o¼Ë¸Õ¸Õif(iserror(vlookup(--a1,...)),vlookup(a1,....),vlookup(--a1,....))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

1.±N¾É¤JexcelªºaÄæ>¸ê®Æ>­åªR>¤å¦r
2.vlookup(a1,...),a1ªºaÄæ¤]­åªR¬°¤å¦r
®æ¦¡¤@­P«á´N¦æ¤F

ÁÂÁ«ü±Ð¤F!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD