Excel鐨凩OOKUP鍑芥暟鎬庝箞浣跨敤
扬州沐宇科技
2023-09-07 18:00:42
excel
Excel鐨凩OOKUP鍑芥暟鐢ㄤ簬鍦ㄦ煇涓寖鍥翠腑鏌ユ壘鎸囧畾鍊硷紝骞惰繑鍥炶鍊兼墍鍦ㄧ殑琛屾垨鍒椾腑鐨勭浉搴斿€笺€?/p>
LOOKUP鍑芥暟鐨勮娉曚负锛?/p>
LOOKUP(lookup_value, lookup_vector, [result_vector])
鍏朵腑锛?/p>
-
lookup_value锛氳鏌ユ壘鐨勫€笺€?/p>
-
lookup_vector锛氭煡鎵捐寖鍥达紝鍗宠鍦ㄥ摢涓寖鍥翠腑鏌ユ壘lookup_value銆?/p>
-
result_vector锛氬彲閫夊弬鏁帮紝鐢ㄤ簬鎸囧畾瑕佽繑鍥炵殑鍊兼墍鍦ㄧ殑鑼冨洿銆傚鏋滅渷鐣ヨ鍙傛暟锛屽垯LOOKUP鍑芥暟灏嗚繑鍥炰笌lookup_value鎵€鍦ㄨ鎴栧垪鐩稿搴旂殑鍊笺€?/p>
浠ヤ笅鏄竴浜涗娇鐢↙OOKUP鍑芥暟鐨勭ず渚嬶細
- 鍦ˋ1:A10鑼冨洿鍐呮煡鎵惧€间负50鐨勫崟鍏冩牸锛屽苟杩斿洖璇ュ崟鍏冩牸鎵€鍦ㄨ涓殑鐩稿簲鍊硷細
=LOOKUP(50, A1:A10, B1:B10)
- 鍦˙1:F1鑼冨洿鍐呮煡鎵惧€间负"apple"鐨勫崟鍏冩牸锛屽苟杩斿洖璇ュ崟鍏冩牸鎵€鍦ㄥ垪涓殑鐩稿簲鍊硷細
=LOOKUP(鈥渁pple鈥? B1:F1, B2:F2)
- 鍦ˋ1:A10鑼冨洿鍐呮煡鎵惧€间负100鐨勫崟鍏冩牸锛屽苟杩斿洖璇ュ崟鍏冩牸鎵€鍦ㄥ垪涓殑鐩稿簲鍊硷細
=LOOKUP(100, A1:A10, B1:F10)
下一条：如何选择java xml的解析库
