- ©«¤l
- 61
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2014-3-5
|
1.¨S¤Hª¾¹D§Aªº©w¸q¦WºÙ "B" ¬O©w¸q¤°»ò...
=VLOOKUP(B2,B!B,3,0)
¬Ý¤½¦¡À³¸Ó¬O©w¸q¦¨ $A$1:$C$4
2.¤£ª¾¹D§Aªº»Ý¨D¬O¤°»ò...
§A¦pªGn¦b B Äæ¿é¤JµM«á¦^¶ÇCÄæ¸ê®Æªº¸Ü§â©w¸q§ï¦¨ B!$B$1:$C$4¡A
¤½¦¡§ï¦¨ =VLOOKUP($B2,B,2,0)
¦pªG¬On¦b A Äæ¿é¤JµM«á¦^¶ÇB¡BCÄ檺¸ê®Æ«h¡A©w¸q§ï¦¨ B!$A$1:$C$4¡A
B2¤½¦¡§ï¦¨ =VLOOKUP($A2,B,COLUMN(),0)
¦V¥k¦V¤U©Ô |
|