- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS XP
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2018-8-1
- ³Ì«áµn¿ý
- 2018-8-2
|
°ÝÃD1:
=VLOOKUP(OFFSET(¤ÀªRªí!B5,-MOD(ROW(¤ÀªRªí!B5)-5,3),0),¸ê®Æ!C:I,6,0) & VLOOKUP(¤ÀªRªí!D5,¸ê®Æ!D:I,6,0)
·Q½Ð±Ð³o¤@¬q¤½¦¡ªº·N«ä~
°ÝÃD2:
¤U¹Ï³Ì¥kÃ䨺¨â¦æ¥H¤Î¶}ÀYªº§Ç¸¹¬O¥²nªº¦s¦b¶Ü?
°ÝÃD¤T:
¦]¬°¦×Ãþ±a°©¸ò¤£±a°©«á¥b¬q´X¥G³£¤@¼Ë¡A¦pªG¥ÎVLOOKUPÂê©w¦M®`¨º³¡¤À...·|¤£·|¦³²V²cªº°ÝÃD?
¬O§_¦³¿ìªk¥u°w¹ï¥[¤u¨BÆJ(¦×ªº¤ÀÃþ)ªºÅܧó¥h±a°Ê«á¤èªº¸ê°T?
°ÝÃD«Ü¦h½Ð¨£½Ì...
¦^´_ 4# a5007185 |
|