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

[µo°Ý] ¥H¾P°â¸ê®Æ¤§(¥æ©ö¤é´Á+±b¸¹)¬d§ä·í®Éªº±b¸¹¨Ï¥ÎªÌ

[µo°Ý] ¥H¾P°â¸ê®Æ¤§(¥æ©ö¤é´Á+±b¸¹)¬d§ä·í®Éªº±b¸¹¨Ï¥ÎªÌ

¥»©«³Ì«á¥Ñ infoverdad ©ó 2015-4-3 23:50 ½s¿è

1. ¸ê®Æ»¡©ú
¨ú±o¤§¾P°â¸ê®Æ¶È¦³¥æ©ö¤é´Á+±b¸¹¡A±ý¬d¸ß¸Óµ§¥æ©ö¬O­þ¤@¦ì¦P¤¯¸g¤âªº?
ªí1: ¾ã²z«á¤§±b¸¹¾ú¥v²M³æ (§Y¬Y±b¸¹¾ú¥ô¸g¤âªÌ©m¦W¤Î¨Ï¥Î¤é´Á°_¨´°Ï¶¡)


ªí2: ¥æ©ö¤é´Á+±b¸¹ (±ý¥H¤½¦¡¬d¸ß±b¸¹¾ú¥v²M³æ¡A±Nµ²ªG±a¤J[±b¸¹¨Ï¥ÎªÌ©m¦W]Äæ¦ì)
¬d¸ß±b¸¹¨Ï¥ÎªÌ.png

2. ¦Û¦æ¹Á¸Õªºµ²ªG(¥Ø«e¼È¥Î¤èªk¦³¤G):
¤èªk1: =VLOOKUP($D4,INDIRECT("±b¸¹¾ú¥v!$B$"&$A4&":$D$"&$B4),3,1)  
¤èªk2: =LOOKUP($D4,INDIRECT("±b¸¹¾ú¥v!$B$"&$A4&":$B$"&$B4),INDIRECT("±b¸¹¾ú¥v!$D$"&$A4&":$D$"&$B4))
¨ä¤¤INDIRECT("±b¸¹¾ú¥v!$B$"&$A4&":$D$"&$B4)µ¥ªí¹F¤è¦¡¬°¦U±b¸¹¤§°_¨´²M³æ½d³ò

3. ·Q½Ð°Ý¬O§_¦³§ó²¼ä¤è«Kªº¤èªk?
´ú¸ÕÀÉ ¬d¸ß±b¸¹¨Ï¥ÎªÌ.rar (9.51 KB)

¦^´_ 1# infoverdad

¤u§@ªí1, E5 ¿é¤J¤½¦¡«á, ¦V¤U½Æ»s :

=LOOKUP(D5,OFFSET(±b¸¹¾ú¥v!A$1,MATCH(C5,CODE,),1,COUNTIF(CODE,C5)),OFFSET(±b¸¹¾ú¥v!A$1,MATCH(C5,CODE,),3,COUNTIF(CODE,C5)))

TOP

¦^´_ 2# JBY


    «D±`·PÁ¡A³o­Ó¤èªk³Ì¤è«K¤F!
    ¶¶«K§â¥|ºØ¤èªk¾ã²z°_¨Ó¦pªþ¥ó
¬d¸ß±b¸¹¨Ï¥ÎªÌ¦@4ºØ¤èªk.rar (11.21 KB)

TOP

¥»©«³Ì«á¥Ñ JBY ©ó 2015-4-4 23:39 ½s¿è
¦^´_  JBY
    «D±`·PÁ¡A³o­Ó¤èªk³Ì¤è«K¤F!
    ¶¶«K§â¥|ºØ¤èªk¾ã²z°_¨Ó¦p....



§ó²³æ¤èªk :

=LOOKUP(2,1/((CODE=C5)/(SDATE<=D5)),Seller)

TOP

¦^´_ 4# JBY


    «z!³o­Ó¤½¦¡§ó¤è«K¡A¤£ºÞ±b¤á¾ú¥v²M³æ¦³¨S¦³¨Ì¤é´Á±Æ§Ç¡A³£¯à±o¨ì¥¿½Tµ²ªG¡C«D±`·PÁ±z, ³o­Ó¯uªº«ÜÆg!
¦A¥[¤J§Úªº¦¬¶°¤¤
¬d¸ß±b¸¹¨Ï¥ÎªÌ¦@5ºØ¤èªk.rar (12.71 KB)

TOP

¥»©«³Ì«á¥Ñ infoverdad ©ó 2015-4-5 01:47 ½s¿è
§ó²³æ¤èªk :

=LOOKUP(2,1/((CODE=C5)/(SDATE
JBY µoªí©ó 2015-4-4 23:38


½Ð°ÝJBY¤j¤j
(CODE=$C5)/(SDATE<=$D5)¤¤¨Ï¥Î°£¸¹¬O§_¦³¯S§Oªº·N¸q?
¸ÕµÛ§ï¬°(CODE=$C5)*(SDATE<=$D5) ? µ²ªG¨ÃµL¤£¦P

TOP

¥»©«³Ì«á¥Ñ JBY ©ó 2015-4-5 22:17 ½s¿è
½Ð°ÝJBY¤j¤j
(CODE=$C5)/(SDATE<=$D5)¤¤¨Ï¥Î°£¸¹¬O§_¦³¯S§Oªº·N¸q?
¸ÕµÛ§ï¬°(CODE=$C5)*(SDATE<=$D5) ? µ²ªG¨ÃµL¤£¦P


=LOOKUP(2,1/(CODE=C5)/(SDATE<=D5),Seller)

=LOOKUP(2,1/(CODE=C5)*(SDATE<=D5),Seller)

¤½¦¡¤¤¨Ï¥Î " / " °£¸¹, ©ÎªÌ  " * " ­¼¸¹, µ²ªG³£¬O¤@¼Ëªº, ¨ÃµL¤£¦P¡C

¥u¬O·Qªí²{¤@点"»P²³¤£¦P", ¨ä¹ê Excel ¤]¥i¥H"ª±" !

¦A¦¸, ¤½¦¡ÁÙ¥i¥H§ï¥Î " + " ¥[¸¹, §A设ªk«ä¦Ò !

TOP

=LOOKUP(2,1/(CODE=C5)/(SDATE<=D5),Seller)

=LOOKUP(2,1/(CODE=C5)*(SDATE<=D5),Seller)


§ó¥¿

º|¥h "¡K1/(¡K¡K)"

=LOOKUP(2,1/((CODE=C5)/(SDATE<=D5)),Seller)

=LOOKUP(2,1/((CODE=C5)*(SDATE<=D5)),Seller)

TOP

¦^´_ 7# JBY


    ÁA¸Ñ¡IÁÂÁÂJBY¤jªº¸É¥R¡I¾Ç²ß¤F¡C

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD