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

½Ð°Ý¤½¦¡¨º¸Ì¦³¿ù??VLOOKUP

½Ð°Ý¤½¦¡¨º¸Ì¦³¿ù??VLOOKUP

¤§«e¥Îªº¦n¦nªº¡A¤µ¤Ñ¬ðµM³£Åܦ¨ #N/A  

½Ð°Ý¸ê®Æ¤Ó¦h·|¤£¯à¤ñ¹ï¶Ü??
¤§«e³Ì¦h¤j·§40µ§¡A¤µ¤Ñ¤ñ¸û¦h´NÅܳo¼Ë¡K



¸ê®Æ¤ñ¹ï.rar (9.19 KB)

¦]§Ú¬O¦Û¤v¬Ý®ÑÃä¾Ç¡K®Ñ¤W¤£¬O«Ü¸ÔºÉ
¥t¥~¸ß°Ý¡AVLOOKUP¥i¸óÀɮרϥζÜ??
¤G­ÓEXCELªí¥h¤ñ¹ï??·PÁÂ~

¬O§_¤íÀÉ??
EDWIN

TOP

¥»©«³Ì«á¥Ñ yenpo5566 ©ó 2016-6-4 12:35 ½s¿è

µy§@­×§ï¡A§A°Ñ¦Ò¬Ý¬Ý¦³¨S¦³À°§U¡C

¸ê®Æ¤ñ¹ï1.rar (9.89 KB)

¸Õ¸Õ¬Ý

EDWIN

TOP

¦^´_ 3# yenpo5566


    §ÚÁÙ¬O¬Ý¤£¥X¨º¸Ì¿ù >"<

   ¦³ÃC¦âªº³¡¥÷¬O§Ú¥Î·j´M¡A¥ª¤è¦³¸ê®Æ¡A¦ý¥kÃä«o±a¤£¥X...

¸ê®Æ¤ñ¹ï1.rar (10.72 KB)

TOP

=IFERROR(VLOOKUP(E2,A$2:B$80,2,),"µL¦¹°U¹B³æ¸¹")

TOP

§ÚµLÅv­­¤UºI§AªºÀɮסA¦ý¬Ý¹Ï±À´úColumn A(¤å¦r®æ¦¡)¡A¦ÓColumn E(¼Æ¦r®æ¦¡) ®æ¦¡¤£¦P

TOP

¦^´_ 4# Beretta

    §Aªº¸ê®Æ
    1.eÄæ ¸ê®Æ­åªR¬°¤å¦r
    2.­×¥¿vlookup¤½¦¡¬d¸ßªº½d³ò
         =VLOOKUP(E2,$A$2:$B$80,2,0)

   ¥u¼g¨ì 55¡A·íµM¬d¤£¨ì

TOP

VLOOKUP ­n±Æ§Ç¤~¯à°Ñ·Ó

TOP

F2 =IFERROR(INDEX(B:B,-LOOKUP(,-MATCH(IF({1,0},--E2,E2&""),A:A,))),"µL¦¹°U¹B³æ¸¹")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD