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

[µo°Ý] Excel¦p¦óÅã¥Ü³Ì·sªº¤é´Á¤Î¸ê®Æ?

[µo°Ý] Excel¦p¦óÅã¥Ü³Ì·sªº¤é´Á¤Î¸ê®Æ?

TEST1.rar (8.35 KB)
½Ð¨D°ª¤â«üÂI:)

B2=VLOOKUP(³øªí!$A2,¸ê®Æ!$A$2:$D$17,COLUMN(B2),)

TOP

¦^´_ 2# ANGELA

·PÁ¤j¤j¦^À³,§Ú§âÀÉ®×¼g§ó©ú¥Õ¨Ç,¦³³Ò¤j¤j嘞
TEST1.rar (7.73 KB)

TOP

¦^´_ 3# h906045

B21=LOOKUP(2,1/($A$2:$A$17=$A21),B$2:B$17)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¤j¤j,¦¨¥\嘞,«Ü¨ØªA§A±zªº¥\¤O,ÁÂÁ§AÅý§Ú¤S¾Ç¨ì¤F°ª©Û

TOP

¦^´_ 4# Hsieh

½Ð°ÝHsieh¤j¤j
B21=LOOKUP(2,1/($A$2:$A$17=$A21),B$2:B$17)
¨ä¤¤(2,1/.........¦³¦ó·N¸q?

TOP

¦^´_ 6# h906045
B21=LOOKUP(2,1/($A$2:$A$17=$A21),B$2:B$17)
³o­n±qLOOKUPªº·j´M¯S©Ê¨Ó¬Ý
¦]¬°$A$2:$A$17=$A21·|²£¥Í¤@­ÓTRUE»PFALSEªºÅÞ¿è°}¦C
·í1°£¥H³o¨ÇÅÞ¿è­È®É
1/TRUE¡÷1/1¡÷1
1/FALSE¡÷1/0¡÷#DIV/0!
³o¼Ë·|±o¨ì¨S¦³±Æ§Çªº1»P¿ù»~­È©Ò§Î¦¨ªº°}¦C
¦ÓLOOKUP¨ç¼Æ¤¤ªº·j´M­È(lookup_value)³]¦¨2
¤@©w·|¤j©ó°}¦C¤¤ªº©Ò¦³¼Æ­È
©Ò¥HLOOKUP·|¶Ç¦^¤p©óµ¥©ólookup_valueªº³Ì¤j­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh

¤£¦n·N«ä,­É³o¤@­Ó°ÝÃD,°Ý¥t¤@­Ó¸ÑÃD.
¦pªG¬O­n§ä³Ì¦­ªº¤é´Á, ¨ç¼Æ¸Ó¦p¦ó¥Î?
fangac

TOP

¦^´_ 8# fangsc


    2#´N¬O§ä¨ì²Ä¤@µ§ªº¸ê®Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# Hsieh

©êºp, §Úªº·N«ä¬O§ä³Ì¦­ªº¤@µ§¸ê®Æ¤Î³Ì«áªº¤@µ§¸ê®Æ.
ªþ¥ó¸Ì, ¥H2#ªº¤½¦¡§ä¨ì²Ä¤@¦¸¥X³fªº¤é´Á, ¦ý¬O¦pªG¬O­n§ä³Ì«á¤@¦¸ªº¥X³f¤é´Á, ¤½¦¡¸Ó¦p¦ó¥Î©O?
·PÁÂ...

³Ì«á¤@¦¸¥X³f¤é´Á.rar (323.84 KB)

fangac

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD