- ©«¤l
- 19
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 29
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-14
- ³Ì«áµn¿ý
- 2023-9-22
|
¦^´_ 3# ANGELA
Áª©¥D! ¦ý¥Î =IF(COUNTIF(Sheet1!B$2:B$65536,A1),VLOOKUP(A1,Sheet1!B2:E65536,2,0),""), µo²{¦p¬Û¹ï·íµ§¸ê®Æ, ¨ì¨S¦³¸ê®ÆªºªÅ®æ®É, ¤§«á¦C¦ì´N·|²£¥Í"0"¤Î"#N/A"
¦p§Ú§ï¥Î
=IF(ISERROR(VLOOKUP(A1,Sheet1!B$2:K$65536,2,FALSE)),"",VLOOKUP(A1,Sheet1!B$2:K$65536,2,FALSE))............3,FALSE, 4,FLASE, 5,FLASEµ¥, ¥ÎA1¦ì¸m¨Ó¹ïÀ³¨C®æ¸ê®Æ, ´N¥i¥H§¹¥þÅã¥Ü¥X¾ãµ§¸ê®Æ¥X¨Ó. ¦ýÁÙ¦³¨S¦³§ó²³æªº¨ç¼Æ©Î¤è¦¡¥i¥H¼g±o§óª½±µ¤Î§Ö³t§â¾ã¦Cªº¸ê®Æ±a¥X©O? |
|