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

[µo°Ý] ½Ð¦U¦ì¤j¤jÀ°§Ú¸Ñµª

[µo°Ý] ½Ð¦U¦ì¤j¤jÀ°§Ú¸Ñµª

¤j®a¦n,¤p§Ì·Q½Ð±Ð¤@¤U¦p¦ó§Q¥Îvlookupªº¤è¦¡Åýexcel§PÂ_¸Ó¿ï­þ¤@¦ì(½Ð¬Ý¹Ï)



Á|¨Ò¨Ó»¡, ¦pªGA7="Ann"ªº¸Ü, ¨º»òexcel´N·|§PÂ_µ¹¨C­Ó¤H2¶ô¿ú. ¦pªGA7="Bob"ªº¸Ü, ¨º»òexcel´N·|§PÂ_¥uµ¹p1¤@­Ó¤H2¶ô¿ú.

¦]¬°¦W³æ«Üªø, ©Ò¥H¥²¶·¥Î¨ìªí®æ. ·PÁ¤j®aªºÀ°¦£.

¦^´_ 1# chrislin2k

³oÀ³¸Ó¬O§A­nªº~¦bA8Àx¦s®æ¤§«á¿é¤J§Aªº¸ê®Æ~
¬¡­¶Ã¯1.rar (7.11 KB)

TOP

=TEXT(INDEX(B:B,MATCH($A8,$A:$A,)),"[=] ")

TOP

¦^´_ 1# chrislin2k

=IF($A7="","",VLOOKUP($A7,$A:$F,COLUMN(),))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD