- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 5# aaaaa388
¥Îcountif()¹LÂo¬O§_¬d±o¨ìÈ
d7=IF(COUNTIF(Á`ªí!$D$25:$H$30,B7),VLOOKUP(B7,Á`ªí!$D$25:$H$30,5,FALSE),"")
¥H¤U¤½¦¡¥i¦V¥k¤Î¤Ucopy
d7=IF(COUNTIF(OFFSET(Á`ªí!$D$25:$H$30,(COLUMN(A1)-1)*9,),$B7),VLOOKUP($B7,OFFSET(Á`ªí!$D$25:$H$30,(COLUMN(A1)-1)*9,),5,FALSE),"") |
|