¡@¼ÊºÙ: ªü¦õ ¡@ÀY»Î: ¤W¯ZµL²á¥´©Ç¥h
¤¤¾Ç¥Í
- ©«¤l
- 108
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 113
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »OÆW
- µù¥U®É¶¡
- 2017-9-7
- ³Ì«áµn¿ý
- 2019-2-27
|
¦^´_ 12# ã´£³¡ªL
¹ê¦b¤Ó·PÁ§A¤F¡I
¤S¾Ç¨ì¤F¤@½Ò¡I
¦pªG LOOKUP ¨ç¼Æ§ä¤£¨ì lookup_value¡A
´N·|¤ñ¹ï lookup_vector ¤¤¤p©ó©Îµ¥©ó lookup_value ªº³Ì¤jÈ¡A
©Ò¥H³]¤@Ó·¥¤jªºlookup_value¡C
https://support.office.com/zh-tw/article/lookup-%E5%87%BD%E6%95%B8-446d94af-663b-451d-8251-369d5e3864cb
¥t¥~½T»{¤@¤U B3ªº¨ç¦¡¬O¤£¬O³o¼Ë³]©w·|§ó·Ç½T¡H- =IFERROR(LOOKUP(9E+307,OFFSET(µn°Oªí!$A:$A,,MATCH(A3,µn°Oªí!$1:$1,)+3)),0)
½Æ»s¥N½X |
|