前沿拓展:
lookup
打開一個Excel表格。根據(jù)工作表左邊的單元格內(nèi)容,即單元格A1到單元格C5的區(qū)域,查找出E2單元格的部門值F2。
如果函數(shù)LOOKUP找不到lookup_value,等日燃雜偉抗燒勞走記則查找array和 lookup_vector中小于lookup_value的最大數(shù)值。如果lookup_value小于array和 lookup_vector中的最小值,函數(shù)LOOKUP返回錯誤值#N/A。
使用方法:
向量形式:公式為 = LOOKUP(lookup_value,lookup_vector,result_vector)式中 loo比率銀說kup_value—函數(shù)LO均楊速受齊更驗命持OKUP在第一個向量中所要查找的數(shù)值,它可以為數(shù)字、來自文本、邏輯值或包含數(shù)值的名稱或引用。
lookup_vector—只包含一行或一列的區(qū)域,其可以是文本、數(shù)字或邏輯值。
result_vector—只包含一行或一列的區(qū)域,其大小必
1. Look up the case and minute me about it.
查看一下案件并把情況以備忘錄方式告訴我。
2. He needed a model, someone to look up to.
他需要個偶像,一個景仰的對象。
3. Let me just look up my notes for the exact data.
讓我查閱一下我的筆記,找出確切數(shù)據(jù)。
4. Things are beginning to look up.
事情有巴望了。
5. They couldn't be bothered to look it up.
他們根本不想花力氣去查這件事。
6. I was going to look for him when he showed up.
我正想去找他,可好他自個兒來了。
7.There's no telling what a girl will look like when she grows up.but for sure she will turn to be prettier and prettier in appearance.
女大十八變,越變越好看。
8.She clicked her tongue and shook her head but did not look up.
她用舌頭發(fā)出嘖嘖的聲音,搖了搖頭, 但是并沒有抬頭看。
原創(chuàng)文章,作者:九賢生活小編,如若轉(zhuǎn)載,請注明出處:http://xiesong.cn/22981.html