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

VLOOKUP´M§äµª®×¤£¦P

¥»©«³Ì«á¥Ñ p212 ©ó 2014-5-30 08:47 ½s¿è

¦^´_ 1# tufe8887
¤u§@ªíNd3¤§Àx¦s®æL9¤½¦¡­×§ï¬°
=IF(B9="","",VLOOKUP(B9,$O$1:$P$19,2,0))©Î
=IF(B9="","",VLOOKUP(B9,$O$1:$P$19,2,FALSE))
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD