- ©«¤l
- 129
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-28
- ³Ì«áµn¿ý
- 2018-11-10
|
¦^´_ 1# missbb
m3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0),)
m3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+1,)
o3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+2,)
p3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+3,)
m3:p3 °é¿ï¦V¤U©Ô
s3=IFERROR(VLOOKUP($A3&S$2,쥻¸ê®Æ!$B$3:$N$65535,6,FALSE),"")
t3=IFERROR(VLOOKUP($A3&T$2,쥻¸ê®Æ!$B$3:$N$65535,8,FALSE),"")
u3=IFERROR(VLOOKUP($A3&U$2,쥻¸ê®Æ!$B$3:$N$65535,9,FALSE),"")
v3=IFERROR(VLOOKUP($A3&V$2,쥻¸ê®Æ!$B$3:$N$65535,12,FALSE),"")
w3=IFERROR(VLOOKUP($A3&W$2,쥻¸ê®Æ!$B$3:$N$65535,13,FALSE),"")
s3:w3°é¿ï¡A¦V¥k ¦V¤U©Ô |
|