- ©«¤l
- 49
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-28
- ³Ì«áµn¿ý
- 2022-6-14
|
¬d
¥»©«³Ì«á¥Ñ ®Ü¦â ©ó 2012-6-6 15:56 ½s¿è
¦^´_ 2# register313
ÁÂÁÂ¥ý¶i«ü¾É¡A´N¤½¦¡¤º®e
K2=IF(ISERROR(MATCH($I2&$J2,$A$2:$A$9&$B$2:$B$9,0)),"",OFFSET($C$2:$D$9,MATCH($I2&$J2,$A$2:$A$9&$B$2:$B$9,0)-1,COLUMN()-11))¤¤ªº¡i-1,COLUMN()-11))¡j¤Î¡iLOOKUP(2,1/(($A$2:$A$9=$I2)*($B$2:$B$9=$J2)),$C$2:$C$9)¡j¥Nªíªº·N«ä¡A·PÁÂ¥ý¶i¦A¦¸«ü¾É¡C¤p§Ì¥t§ï¦¨¸ó¶¬d¸ß¸ê®Æ~µ²ªG¥X²{¿ù»~
k=INDEX(Sheet2!$A$2:$E$9,IF(ISERROR(LOOKUP(2,1/((Sheet2!$A$2:$A$9=$J2)*(Sheet2!$C$2:$C$9=$K2)),Sheet2!D2:D9)),"",LOOKUP(2,1/((Sheet2!$A$2:$A$9=$J2)*(Sheet2!$C$2:$C$9=$K2)),Sheet2!$D$2:$D$9)))~½Ð¥ý¶i«ü¾Én¦p¦ó§ó§ï~·PÁÂ~ |
|