[µo°Ý] ¸ê®Æ¦Û°ÊÅã¥Üªº°ÝÃD

ckinwing

¤â°Ê¿é¤JAÄæ©MBÄæ¡AµM«á·QÅýCÄæ®Ú¾Ú¥kÃäL2:N22ªº¸ê®Æ¦Û°ÊÅã¥Ü¥X¬ÛÃö¥DÃD¡A½Ð°Ý¸Ó«ç»ò¼g¡H
¸Õ¤F¥ÎVlookup¡A¥i¬O¦³¨â­Ó±ø¥ó­­¨î¡A©Ò¥H¤£¦¨¥\¡C

test.rar (9.05 KB)

¤U¸ü¦¸¼Æ: 20

2011-3-31 13:23

jim

¸Õ¸Õ¥i¬Û®e©Ê³n¥ó

ann

¤U¸ü (75.1 KB)

2011-4-16 18:25

³o¬O¤§«e§Ú¦³Ãþ¦üªº°ÝÃD
ª©¥D¤j¤H´£¨Ñ§Ú§Q¥Îoffset»Pmatch¨â¨ç¼Æ
´À§Ú¸Ñ¨M·Ð¸£
¦b¦¹³¥¤HÄmÃnµ¹±z°Ñ¦Ò
¦bC2¿é¤J
{=OFFSET($N$1,MATCH($A2&$B2,$L$2:$L$22&$M$2:$M$22,0),)}
´£¿ô:§¹¦¨«áctrl+shift+enter »ô«ö¤~¯à¥X²{{}


¦A¥[¤W§Q¥ÎIF¥h§PÂ_
{=IF(ISNUMBER(MATCH($A2&$B2,$L$2:$L$22&$M$2:$M$2,0)),  ¬O§_¬°TRUE,­Y±ø¥ó¦¨¥ß«h
OFFSET($N$1,MATCH($A2&$B2,$L$2:$L$22&$M$2:$M$22,0),),  ¤£¦¨¥ß«h
"")}

¥H¤W¬O·s¤â±o«e½ú¬Û§U«á¤£¦Û¶q¤O¦a·Q¤p¤p¦^õX
­Y¦³¿ù»~ÁٽЫe½ú­Ì«üÂI¤@¤G




­Y²z¸Ñ¦³»~ÁٽЫe½ú­Ì«üÂI

onegirl0204

¦^´_ 1# ckinwing


¤£¦n·N«ä¡ã§Ú®aªºexcel¬O2003ª©ªº¡A±zªºÀɮ׬O2010·sª©ªº¡ãµLªk¶}±Ò¡A¥i§_Âà¦sª©®æ¦¡©O¡HÁÂÁ¡I

yanto913

=IF(ISERROR(LOOKUP(2,1/($L$2:$L$22=A2)/($M$2:$M$22=B2),$N$2:$N$22))=TRUE,"",LOOKUP(2,1/($L$2:$L$22=A2)/($M$2:$M$22=B2),$N$2:$N$22))

ckinwing

¦¨¥\¤F~ ¥i¬O­Y¸ê®Æ¤£¥¿½Tªº¸Ü¡A­nÅã¥ÜªÅ¥Õ¦Ó¤£¬O#N/A,¸Ó«ç»ò¼g¡H
ÁÙ¦³¡A«e­±ªº2©M1½Ð°Ý¬O¤°麽·N«ä¡H

chin15

=LOOKUP(2,1/($L$2:$L$22=A2)/($M$2:$M$22=B2),$N$2:$N$22)