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鍗曞厓镙,杩欐牱褰㈡垚浜嗕竴涓涓镄勫潗镙,镙囨槑浜嗘疮涓鍗曞厓镙肩殑浣岖疆.