- ©«¤l
- 16
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2013-4-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ lucky_jocky
sheet2!A3°}¦C¤½¦¡(ctrl+shift+enter)
=IFERROR(INDEX(Sheet1!$BB,SMALL(IF(Shee ...
Bodhidharma µoªí©ó 2013-4-10 18:56
®Ú¾Ú®v¥S§A´£¨Ñªº¤½¦¡¡A§Úpºâ¬O 0 §r??
¨ä¹ê§Ú¥Î
=IF(ISERROR(VLOOKUP($A1,'Sheet1'!$A$2:$D$12,2,0)),"",VLOOKUP($A1,'Sheet1'!$A$2:$D$12,2,0))
¦ý¥u¥i¥H§ä¨ìA2 , B2, C2, D2
¤§«áªº´N§äø¨ì~~~ |
|