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

[µo°Ý] VLOOKUP¤ñ¹ï¤£¥X¨Ó

[µo°Ý] VLOOKUP¤ñ¹ï¤£¥X¨Ó

¦U¦ì«e½ú­Ì¦n
§Ú­n§â0307-0318 ³o¨â­Ó¤u§@ªíªº¹s¥ó¥N¸¹°µ°Ï¤À
·N«ä´N¬O³o¬q´Á¶¡¤º ¦³­þ¨Ç¬O·s¼W¥X¨Óªº¹s¥ó¥N¸¹

¦]¬°§Ú¦Û¤v¥ÎVLOOKUP¥h°µ¤ñ¹ï ¤@ª½³£¬ON/A
«Ü­W´oªº»¡....
½Æ»s.rar (12.51 KB)

¥i¥H¶K¹Ï¶Ü? ¥Ø«eµL¤U¸üÅv­­
¥i¥H¥ý½T»{ ¤ñ¹ï¦C¬O§_¦³ªÅ®æ ÁÙ¬O ¤£²Å

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-18 17:18 ½s¿è

¦^´_ 1# wangyihong24
¥H¡u0307¡v¤u§@ªí¬°°ò·Ç¡A¦b¡u0318¡v¤u§@ªí¤§Àx¦s®æH2¿é¤J¤½¦¡
=IF(ISNUMBER(MATCH(A2,'0307'!$A:$A)),"·s¼W","")
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 3# p212


    §A¦n «e½ú §Ú¬Ý¤£À´³o¸Ì
    =IF(ISNUMBER(MATCH(A2,'0307'!$A:$A)),"·s¼W","")
   ¸Ó«ç»ò½Õ¾ã
¦]¬°¤@ª½¤½¦¡¿ù»~

TOP

¦^´_ 4# wangyihong24
´N1#ªº½d¨Ò¦Ó¨¥¡A½Ð°Ý±z´Á«Ýªºµª®×¬O¤°»ò¡H
¥i¥H¥Î1#ªºÀÉ®×´£¨Ñ¤@¤U½d¨Ò¡H
ÁÂÁ¡I

TOP

¤ñ¹ïµ²ªG¬° NA ¬O ¤½¦¡¥¿½T ¤ñ¹ïµL¸ê®Æ
À³¸Ó¬O­n½T»{ ¤ñ¹ï Ãþ ¬O§_¦³¬Û²§¼Æ¾Ú
³Ì²³æªº½T»{¤èªk ´N¬O ¦Û¤v¥h§ä ¤@¹ï ¬Û²Åªº¼Æ¾Ú
½T»{¤@¤U ³o2µ§ ¬O§_ ¼W´î¤°»ò ³y¦¨ ¤ñ¹ï¤£¨ì

TOP

¾Ç²ß¾Ç²ß!!!!!!!!!!!!!!

TOP

¦^´_ 1# wangyihong24

·s¹s¥ó.rar (13.39 KB)

·s¹s¥ó.png (52.09 KB)

·s¹s¥ó.png

TOP

H2 =IF(COUNTIF('0307'!A:A,A2),"§_","¬O")
©¹¤U½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

.......§â0307-0318 ³o¨â­Ó¤u§@ªíªº¹s¥ó¥N¸¹°µ°Ï¤À, ¦³­þ¨Ç¬O·s¼W¥X¨Óªº¹s¥ó ...


·s¼W¹s¥ó¥N¸¹, 0318¤u§@ªí¦³, ¦ý, 0307¤u§@ªí¨S¦³,

0318¤u§@ªí, H2, ¿é¤J°}¦C¤½¦¡ (¤@»ô«ö Ctrl + Alt + Enter 3Áä ) :

=IFERROR(INDEX(A$2:A$31,SMALL(IF(ISERROR(MATCH(A$2:A$31,'0307'!A$2:A$36,0)),ROW(A$1:A$30)),ROW(1:1))),"")

¤½¦¡¦V¤U½Æ»s

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD