½Ð°Ýworksheet name ¦p¦ó¼g¦¨formula?
- ©«¤l
- 28
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- window
- ³nÅ骩¥»
- office 2000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- Hong Kong
- µù¥U®É¶¡
- 2011-1-14
- ³Ì«áµn¿ý
- 2021-8-27
|
½Ð°Ýworksheet name ¦p¦ó¼g¦¨formula?
¦U¦ì°ª¤â, ¤p©f¤S¦³ºÃÃø..¥»¤H·Q±Nworksheet name©ñ¦b cell ¤W.... µM«á¼gformula¬O«ü¦V¸Ócell§ä´M¨ºÓworksheet, ¨Ò¦p.....
column A = code no.
column B = worksheet name
C1 = Jan D1 = Feb
A2 = 12345, B2 = ³¯¤j¤å
A3 = 24689, B3 = ¶À¤¤¤å
A4 = 36912, B4 = ©P¤p¤å
¦p§Ú·Q¦bC2 ´M§äworksheet("³¯¤j¤å") ùتº¤@¤ë¥÷¸ê®Æ.... ¨Ò¦p : INDEX("'" & B2 & "'!$D:$D,MATCH(C1,"" & B2 & "'!$B:$B,0)))
¦p¦ó±Nworksheet name, ¥Îcell ¥N´À
ÁÂÁÂ |
|
|
|
|
|
|