[µo°Ý] VLOOKUP¶Ç¦^ªº­È¬O0¦Ó¤£¬O#N/A!?

013160

=VLOOKUP(A1037,Á`ªí!A:C,3,0)
A1037ªº­ÈÀ³¸Ó¬°#N/A¡A¦ý¬°¦ó¶Ç¦^ªº­È¬O0!?

JBY

1] A1037 =  ªÅ , Á`ªí!A1037 = 0 , ---> VLOOKUP ¤½¦¡ ¶Ç¦^ 0

2] A1037 =  ªÅ , Á`ªí!A1037 = ªÅ , ---> VLOOKUP ¤½¦¡ ¶Ç¦^ #N/A

JBY

¶Ç¦^ #N/A , ¤½¦¡ §ï¬° :

=IF(A1037<>"",VLOOKUP(A1037,Á`ªí!A:C,3,0),#N/A)

013160

¥i¯à¬O§Úªí¹F¤£¦n¨Ò¤l¦p¤U­z¡G
¨Ï¥Î¤½¦¡¡÷¡@=VLOOKUP(A1037,Á`ªí!A:C,3,0)
A1037ªº­ÈÀ³¶Ç¦^" "½T¥X²{0
A1038ªº­ÈÀ³¶Ç¦^"JACK"½T¤£·|¥X²{"JACK"¦r¼Ë
¸ÕµÛ®M¥Î¨â¦ì©Ò»¡ªº¤½¦¡½T¦^¶Ç¤£¥X§Ú­nªº­È
¬°¤°»ò!?

JBY

1] ¦pªG  : A1038 ¨Ï¥Î¤½¦¡¡÷ =VLOOKUP(A1037,Á`ªí!A:C,3,0) ¤£¯à¶Ç¦^"JACK"¦r¼Ë

2] Àˬd§Aªºªí®æ, A1037 ,  Á`ªí!A1037 , ¤Î Á`ªí!C1037 ªº­È

3] À³¸Ó¬O : A1037ªº­È = Á`ªí!A1037ªº­È ; ¥H¤Î Á`ªí!C1037 = "JACK"

4] ¦pªG [3]  ¥þ¬O¥¿½Tªº¸Ü, ¥i¥H¶Ç¦^"JACK"¦r¼Ë; §_«h, ¤£·|¥X²{"JACK"¦r¼Ë

013160

¦^´_ 5# JBY


   ÁÂÁ¡A¤w¸Ñ¨M¦¹°ÝÃD¤F!!