A. 濡備綍鍦‥XCEL涓灝嗕竴涓鍏寮忚漿鍖栦負涓涓鏁板箋
涓銆佽繖鍙浠ョ敤INDIRECT鍑芥暟鏉ュ畬鎴愩
浜屻両NDIRECT鍑芥暟鐨勫畾涔夛細
榪斿洖鐢辨枃鏈瀛楃︿覆鎸囧畾鐨勫紩鐢ㄣ傛ゅ嚱鏁扮珛鍗沖瑰紩鐢ㄨ繘琛岃＄畻錛屽苟鏄劇ず鍏跺唴瀹廣傚綋闇瑕佹洿鏀瑰叕寮忎腑鍗曞厓鏍肩殑寮曠敤錛岃屼笉鏇存敼鍏寮忔湰韜錛岃蜂嬌鐢ㄥ嚱鏁 INDIRECT銆
璇娉
INDIRECT(ref_text,a1)
Ref_text 涓哄瑰崟鍏冩牸鐨勫紩鐢錛屾ゅ崟鍏冩牸鍙浠ュ寘鍚 A1-鏍峰紡鐨勫紩鐢ㄣ丷1C1-鏍峰紡鐨勫紩鐢ㄣ佸畾涔変負寮曠敤鐨勫悕縐版垨瀵規枃鏈瀛楃︿覆鍗曞厓鏍肩殑寮曠敤銆傚傛灉 ref_text 涓嶆槸鍚堟硶鐨勫崟鍏冩牸鐨勫紩鐢錛屽嚱鏁 INDIRECT 榪斿洖閿欒鍊 #REF!銆
濡傛灉 ref_text 鏄瀵瑰彟涓涓宸ヤ綔綈跨殑寮曠敤錛堝栭儴寮曠敤錛夛紝鍒欓偅涓宸ヤ綔綈垮繀欏昏鎵撳紑銆傚傛灉婧愬伐浣滅翱娌℃湁鎵撳紑錛屽嚱鏁 INDIRECT 榪斿洖閿欒鍊 #REF!銆
A1 涓轟竴閫昏緫鍊礆紝鎸囨槑鍖呭惈鍦ㄥ崟鍏冩牸 ref_text 涓鐨勫紩鐢ㄧ殑綾誨瀷銆
濡傛灉 a1 涓 TRUE 鎴栫渷鐣ワ紝ref_text 琚瑙ｉ噴涓 A1-鏍峰紡鐨勫紩鐢ㄣ
濡傛灉 a1 涓 FALSE錛宺ef_text 琚瑙ｉ噴涓 R1C1-鏍峰紡鐨勫紩鐢ㄣ
涓夈佷婦渚
錛1錛夊亣璁懼湪A1鍗曞厓鏍間腑鍐欏叆鎴栫敱鍏寮忓緱鍑衡淏100鈥濊繖鏍風殑鏁版嵁錛屾兂鍦˙1鍗曞厓鏍煎緱鍑築100鍗曞厓鏍肩殑鍐呭癸紙鍗矨1鍗曞厓鏍煎啓鍏ユ枃鏈鍗曞厓鏍煎湴鍧錛屽湪B1鍗曞厓鏍煎緱鍑鴻繖涓鍗曞厓鏍肩殑鍐呭癸級錛屽垯B1鍗曞厓鏍煎啓鍏ュ叕寮忥細
=INDIRECT(A1)
錛2錛夊亣璁懼湪A1鍗曞厓鏍間腑鍐欏叆鏁板瓧50錛屾兂鍦˙1鍗曞厓鏍煎緱鍑篊50鍗曞厓鏍肩殑鍐呭癸紙鍗矨1鍗曞厓鏍煎啓鍏ヨ屾暟錛屽湪B1鍗曞厓鏍煎緱鍑篊鍒楄ヨ屽崟鍏冩牸鐨勫唴瀹癸級錛屽垯B1鍗曞厓鏍煎啓鍏ュ叕寮忥細
=INDIRECT("C"&A1)
錛3錛夊亣璁懼湪A1鍗曞厓鏍間腑鍐欏叆瀛楁瘝"H"錛屾兂鍦˙1鍗曞厓鏍煎緱鍑篐20鍗曞厓鏍肩殑鍐呭癸紙鍗矨1鍗曞厓鏍煎啓鍏ュ垪鍚嶏紝鍦˙1鍗曞厓鏍煎緱鍑虹20琛岃ュ垪鍗曞厓鏍肩殑鍐呭癸級錛屽垯B1鍗曞厓鏍煎啓鍏ュ叕寮忥細
=INDIRECT(A1&20)
錛4錛夊亣璁懼湪A1鍗曞厓鏍間腑鍐欏叆瀛楁瘝"G"錛屽湪B1鍗曞厓鏍煎啓鍏ユ暟瀛40錛屾兂鍦–1鍗曞厓鏍煎緱鍑篏40鍗曞厓鏍肩殑鍐呭癸紙鍗矨1鍗曞厓鏍煎啓鍏ュ垪鍚嶏紝B1鍗曞厓鏍煎啓鍏ヨ屾暟錛岃佸緱鍑哄垪鍚嶅拰琛屾暟緇勬垚鐨勫崟鍏冩牸鐨勫唴瀹癸級錛屽垯C1鍗曞厓鏍煎啓鍏ュ叕寮忥細
=INDIRECT(A1&B1)
鍥涖佸崟鍏冩牸鍦板潃
琛ㄦ牸鐨勯《涓婃槸涓鎺掑瓧姣岮,B,C,.......榪欎釜灝辨槸鍒楁爣
琛ㄦ牸鐨勫乏杈規槸涓絝栧垪鐨勬暟瀛1,2,3,.......榪欎釜灝辨槸琛屽彿
鍒楁爣鍔犱笂琛屽彿灝辨槸灝辨槸鍗曞厓鏍肩殑鍚嶇О,鍗曞厓鏍煎悕縐頒篃鍙鍋氬崟鍏冩牸鍦板潃,濡侫鍒楃殑絎涓夎,涓篈3鍗曞厓鏍,C鍒楃殑絎18琛屼負C18鍗曞厓鏍,絎浜斿垪鐨勭涓冭屽氨鏄疎7鍗曞厓鏍,榪欐牱褰㈡垚浜嗕竴涓涓鐨勫潗鏍,鏍囨槑浜嗘瘡涓鍗曞厓鏍肩殑浣嶇疆.