[µo°Ý] indexªº¥Îªk

PJChen

½Ð±Ð«e½úindex¥Îªk.........¥ýÁÂÁ¤F. (¦pªG§Ú¨Ï¥Îªº¨ç¼Æ¤£²z·Q,¬O§_¯à±Ð¨ä¥Lªº?)
¦bPKG sheet¤¤BÄ檺item¦³³\¦h®Æ¸¹,¦bPI sheet¤]¦³¬Û¦Pªº®Æ¸¹(AÄ檺item¥u¥X²{¤@¦¸),¦p¦óÅýPKG sheetªºB38¬°31564-8¦p¦ó¥H·j´Mªº¤èªk«ü©w¥¦±a¥XPI¤¤ªº31564-8ªºBÄæ¸ê®Æ?
§Ú¦Û¤v­J¶Ã¹Á¸Õ:¥HINDEX©MMATCH¬°¤½¦¡,¦ý¥¦¯à±a¥X²Ä¤@µ§¸ê®Æ.

¨Ò:§Ú·Q¦bPKG sheet¤¤D16~D24¥X²{¥H¤Uªº¸ê®Æ
100% BRUSHED COTTON TWILL WOVEN CAP
101% BRUSHED COTTON TWILL WOVEN CAP
102% BRUSHED COTTON TWILL WOVEN CAP
103% BRUSHED COTTON TWILL WOVEN CAP
104% BRUSHED COTTON TWILL WOVEN CAP
1 panel cap
2 panel cap
3 panel cap
4 panel cap

indexÀ³¥Î.zip (22.67 KB)

¤U¸ü¦¸¼Æ: 18

2012-11-24 21:44

4 panel cap

ML089

PKG D16¤½¦¡
=INDEX(PI!$B:$B,MATCH($B16,PI!$A:$A,0)+IF(B16<>B15,0,ROW(B16)-MATCH(B16,B:B,)))
¤U©Ô
¦pªG¹ï¤F¦A©¹¤W½Æ»s¤½¦¡

PJChen

¦^´_ 2# ML089

ÁÂÁ§A,¤½¦¡¥i¥H¹B§@¤F,·Q½Ð°ÝMATCHªº¯S©Ê¬O§_»PVLOOKUP¤@¼Ë?¥H³o¤G­Ó¨ç¼Æ§@¤ñ¹ï®É,·í¬Û¦Pªº­È­«½Æ®É,¥¦¥u·|±a¥X³Ì¤W­±¤@­Ó?
¨Ò¦p:
=MATCH(B16,B:B,)
=VLOOKUP(B16,PI!A:B,2,0)

ML089

¦^´_ 3# PJChen
=MATCH(B16,B:B,)
=VLOOKUP(B16,PI!A:B,2,0)
¥u·|§ä¨ì²Ä¤@­Ó

PJChen

¦^´_ 4# ML089
·PÁÂ!

zz5151353

PKG¤u§@ªí D12 ¶}©l§a ¤½¦¡©¹¤U©Ô
{=INDEX(PI!B:B,SMALL(IF((PI!B$6:B$34<>"")*(LOOKUP(ROW($6:$34),IF(PI!A$6:A$34<>"",ROW($6:$34)),PI!A$6:A$34)=B12),ROW($6:$34),4^8),COUNTIF(B$12:B12,B12)))}

PJChen

¦^´_ 6# zz5151353
§Ú¹ï°}¦C¤£¼ô,½Ð°Ý¸ê®Æ­Y¬O¤£Â_ªº¼W¥[,¾A¦X¥Î¶Ü?

Hsieh

¦^´_ 7# PJChen
°²³]PI!BÄæ¸ê®Æ³Ì¦h¨ì200¦C

D12=INDEX(OFFSET(PI!$B$1,MATCH(PKG!$B12,PI!$A:$A,0)-1,,LOOKUP(2,1/(PI!$B$1:$B$200<>""),ROW(PKG!$1:$200))-MATCH(PKG!$B12,PI!$A:$A,0)+1,),COUNTIF($B$11:B12,B12),)
¦V¤U½Æ»s

PJChen

·PÁ¨þ!¤S¾Ç¨ì¤@ºØ¤½¦¡¥Îªk,¯u¶}¤ß!