[µo°Ý] Àx¦s®æ¬°ªÅ¥Õ,¦ý¨Ï¥Î¨ç¼Æ«o¥X²{0

onegirl0204

½Ð±Ð¦U¦ì«e½ú¬°¦ó¨Ï¥Î¦p¤U¨ç¼Æ,Àx¦s®æ¬°ªÅ¥Õ®É,µ²ªG¥X²{0,½Ð±Ð¦p¦ó­×§ï¤~¯à¨ÏÀx¦s®æ¬°ªÅ¥Õ®É,µ²ªG¤]¥X²{ªÅ¥Õ?
·PÁ½ç±Ð!
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

samwang

¦^´_ 1# onegirl0204


    ISERROR §ï¬° ISBLANK ¸Õ¬Ý¬Ý§a

Leo1318

¦^´_ 1# onegirl0204

Àx¦s®æ~¦Û­q
0;; _0;;

ML089

=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

kerryzz

¦b¤½¦¡³Ì«á¥[¤W &""

onegirl0204

§ï¥ÎISBLANK ~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(ISBLANK(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

Àx¦s®æ~¦Û­q0;; _0;;
µ²ªG¤]¥X²{¿ù»~

¤U¸ü (81.09 KB)

2015-6-2 21:55

§ï¥Î¨ç¼Æ=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

¦b¤½¦¡³Ì«á¥[¤W &"" ~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))&""

JBY

¦^´_ 6# onegirl0204

¤U¸ü (80.2 KB)

2015-6-5 15:19

Àx¦s®æ¬°ªÅ¥Õ®É, µ²ªG¤]¥X²{ªÅ¥Õ, ¤½¦¡ :

1. Excel 2007 ©Î¥H¤Wª©¥», E2 ¤½¦¡¦V¤U½Æ»s :

=IF(D2="","",IFERROR(1/(1/(VLOOKUP(D2,A$2:B$6,2,0))),""))

2. Excel 2003 ©Î¥H¤Uª©¥», F2 ¤½¦¡¦V¤U½Æ»s :

=IF(D2="","",IF(ISERROR(1/(1/(VLOOKUP(D2,A$2:B$6,2,0)))),"",VLOOKUP(D2,A$2:B$6,2,0)))

Farnsworth

¦^´_ 1# onegirl0204
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))
§ï为
=IF(IFERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

   ISERROR  §ï为   IFERROR

这

JBY

¦^´_  onegirl0204......§ï为
=IF(IFERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))....

°ò¥»¤W, §A¤£À´±o¦p¦ó¨Ï¥Î IFERROR !