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

[µo°Ý] ¤U©Ô²M³æ ¥Î VLOOKUP ´M§ä ¦r¦ê¥N½X «ç·|¥X²{¿ù»~©O?

[µo°Ý] ¤U©Ô²M³æ ¥Î VLOOKUP ´M§ä ¦r¦ê¥N½X «ç·|¥X²{¿ù»~©O?

§Ú¤U©Ô²M³æB1 (¤½¦¡ Àç·~¦¬¤J)  ¨Ã¤½¦¡  ©w¸q   ·j´M  ­n§ä  ¾P³f¦¬¤J  ¥N½X 102 ¦ba1    «ç·|¥X²{¿ù»~©O
Book1.rar (3.83 KB)
HI

¦^´_ 1# mycmyc

¬Ý°_¨Ó¬O¤½¦¡³]¿ù¤F,½Ð¥ýÁA¸Ñ VLOOKUP ªº¥Îªk.
=VLOOKUP(B1,·j´M,1,FALSE) ³o¬O¿ù»~ªº¥Îªk.

¦pªG¬O¤@¯ëªº¥Îªk,±zªº ºÞ²z ­¶­±,A©MBÄ檺¸ê®ÆÀ³¹ï´«,
¤½¦¡§ï¬° =VLOOKUP(B1,·j´M,2,FALSE)

¦pªG¤£·Q§ó§ï¸ê®Æ¨Ó·½,¥iª½±µ§ï¥Î¤U¦C¤½¦¡
A1¤½¦¡ =VLOOKUP(B1,IF({1,0},Àç·~¦¬¤J,ºÞ²z!A2:A13),2,0)

TOP

¥»©«³Ì«á¥Ñ mycmyc ©ó 2010-11-1 22:12 ½s¿è

¦^´_ 2# jackdream
·PÁ  ¥i¥H  ¥i¥H»¡¤@¤U§Ú VLOOKUP  ¿ù»~Æ[©À¶Ü  §Ú¬d§ä«Ü¤[ ´N¬OÂण¹L¨Ó
ÁÙ¦³ IF({1,0}  ¤§¤¤  {1,0}  ¬O¥Nªí¬Æ»ò©O
ÁÂÁÂ
HI

TOP

¥»©«³Ì«á¥Ñ jackdream ©ó 2010-11-1 22:24 ½s¿è

¦^´_ 3# mycmyc

ºô¸ô¤W·j´M¤@¤U´N¦³Åo.
http://tw.myblog.yahoo.com/jw!OP ... --/article?mid=1411

½׾¤]¦³¬ÛÃö¸ê®Æ
http://gb.twbts.com/index.php?topic=455.10

TOP

·PÁÂ
http://tw.myblog.yahoo.com/jw!OP ... --/article?mid=1411 ³o½g§Ú¦³·j´M¨ì
¦ýÅé·|¤£¥X ¥u¯à²Ä¤@Äæ  ¬d²Ä¤GÄæ  ©Ò¥H»~¥Î«Ü¤[  
²{¦bª¾¹D ¥u¯à²Ä¤@Äæ  ¬d²Ä¤GÄæ
IF({1,0}  ¥iºâ¬O Äæ¦ì¹ï½Õ   ÁÂÁ§A
HI

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD