- ©«¤l
- 41
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2014-7-27
- ³Ì«áµn¿ý
- 2021-5-22
|
¦]¬°¤£¯à¸üÀÉ®× ¥u¯àµ¹±z±N´N¬Ý
¥ÎVLOOKUP(A,B,C) OR HLOOKUP(A,B,C)
A=C3Àx¦s®æ,µ¹¿é¤JªÌ¿é¤Jªº¸ê®Æ
B=¿ï¨ú¸ê®Æ®w½d³ò
C=·í´M§ä¨ìAÈ,n¦^¶Ç¸ê®Æ®w¤¤AÈ
±o¥ªÃä²Ä´XÓ¦ì¤l
©Î
AȤU¤è²Ä´Xªº¦ì¤l
=VLOOKUP(A1,Z1:ZA20,3)
·N«ä¬O»¡
¤ô¥´M§ä Z1¨ìZ30 ¤¤A1¤§È
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤@ÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,2)
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤GÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,3)
§Æ±æ§AÀ´ |
|