ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Á~¸ê©Ò±oµ|¦©Ãº°ÝÃD

H2 ªº¤½¦¡¡Gµ²ªG#N/A (¤£¥i¥Î)
=VLOOKUP($B2, INDIRECT("taxDB"),$K2+2,)

H3 ªº¤½¦¡¡Gµ²ªG¬°0 (¥¿½T¤½¦¡)
=VLOOKUP($B3, INDIRECT("taxDB"),$K3+2,TRUE)

¤£¬O»¡ Vlookup ªº³Ì«á¤@­Ó°Ñ¼Æ¬° Ture ®É, ¥i¥H¬Ù²¤¶Ü?
¬°¦óH2©MH3ªºµ²ªG·|¤£¤@¼Ë?


Á~¸ê©Ò±o¦©Ãºµ|ÃBªí.rar
http://www.mediafire.com/download/91p83vfs94f0u5y/%E8%96%AA%E8%B3%87%E6%89%80%E5%BE%97%E6%89%A3%E7%B9%B3%E7%A8%85%E9%A1%8D%E8%A1%A8.rar

TOP

¸Õ¸Õ¬Ý¡G
¤@¡Bsheet("102¦~")­×§ï¦p¤U¹Ï¡G

¤G¡B
sheet("Á~¸êªí")B2¿é¤J¤½¦¡¦p¤U¡G
=VLOOKUP($B2, '102¦~'!$B$3N$334, $K2+2,TRUE)
´ú¸Õµ²ªG¦p¤U¹Ï¡G

TOP

¦^´_ 10# ML089
¤j¤j§A¦n!!

¬°¤°»ò B2 ªº¤½¦¡

=VLOOKUP($B2, '102¦~'!$B$3:$N$334, $K2+2,TRUE)
©M
=VLOOKUP($B2, '102¦~'!$B$3:$N$334, $K2+2,)

ªºµ²ªG·|¤£¤@¼Ë?
(¦pªG¤U­±ªºµ²ªG¬° 0, ¤W­±ªºµ²ªG¬° #N/A)

¤£¬O»¡ ¼Ò½k¬d¸ß ®É, True ¥i¥H¬Ù²¤¶Ü?
ÁÙ¬O§Ú­þ­Ó¦a¤è§Ë¿ù¤F?

TOP

¦^´_ 10# ML089
ÁÂÁ¤j¤jªº¦^ÂÐ!!
´«¥y¸Ü»¡¡GExcel ªº»¡©ú, ¬O¦³³´¨Àªº, ³Ì¦n¤£­n¬Ù²¤. ¬O¶Ü?
­ì»¡©ú¦p¤U¡G
¡y¡E¦pªG range_lookup ¬° TRUE ©Î³Q¬Ù²¤¡A«h¶Ç¦^§¹¥þ²Å¦X©Î¤j¬ù²Å¦Xªº­È¡C
¦pªG§ä¤£¨ì§¹¥þ²Å¦Xªº­È¡A±N·|¶Ç¦^¶È¦¸©ó lookup_value ªº­È¡C¡z
¤F¸Ñ¤F!!

TOP

¦^´_ 15# ML089
ÁÂÁ¤j¤jªº«üÂI!!
¤£¹L·U·Q·U¤£¹ï¡A
0=False, 1=True,

¦pªG
¡y=VLOOKUP($B2, '102¦~'!$B$3:$N$334, $K2+2,)
¦P¤U¦C2¦¡
=VLOOKUP($B2, '102¦~'!$B$3:$N$334, $K2+2,0)
=VLOOKUP($B2, '102¦~'!$B$3:$N$334, $K2+2,FALSE)¡z
¨º°Z¤£ªí¥Ü FALSE ¥i¥H¬Ù²¤?

À³¸Ó¬O§Oªº°ÝÃD§a!!

TOP

¦^´_ 10# ML089
¯u·PÁ¤j¤jªº«üÂI°g¬z,
­ì¨Ó®t¦b¤@­Ó³r¸¹, ¦pªG¤£¬O¤j¤j¦A¤T»¡©ú,
¯u¤£ª¾°ÝÃD¥X¦b­þ¸Ì,
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2)
©M
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2, 1)
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2, TRUE)
¬Û¦P, ¦Ó
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2,)
©M
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2, 0)
=VLOOKUP($B3, '102¦~'!$B$3:$N$334,$K3+2, false)
¬Û¦P,
¨S¦³°ª¤H«üÂI, ÁÙ¤£ª¾¦Û¤w¿ù¦b­þ¸Ì,
­ì¨Ó­n¬Ù²¤, ÁÙ¦³¨º»ò¦h¬Ü¨¤, Á°Õ!!

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD