- ©«¤l
- 16
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOS 7
- ³nÅ骩¥»
- office 2013
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-8-3
- ³Ì«áµn¿ý
- 2019-3-19
|
[µo°Ý] ½Ð°Ý¤@¤U¦p¦ó§â¤@Ó½d³òÂন¤@Ó©ú²Óªí(¤u§@ªí)?
Á|¨Ò
A1:B100 ©w¸q¬° ©ú²Óªí¤@
¦Ó§Ú¦b¥´¤½¦¡®É´N¥i¥H¥´¦¨
=vlookup(A1,©ú²Óªí¤@,5)
¦Ó¤£¥Î¥´¦¨
=vlookup(A1,A1:A100,5)
´¿¸g¬Ý¹L¦³¤H³o¼Ë¤l§@excelªí¡A·Q¾Ç¬Ý¬Ý |
|