如何查表格中的某一栏数据

❶ 濡备綍鍦ㄨ〃镙间腑镆ユ垒鎸囧畾鏁版嵁鍖哄烟涓镄勬暟鎹锛

1銆侀栧厛镓揿紑excel2016杞浠讹纴鏂板缓涓涓琛ㄦ牸锛屽啓鍏ユ暟鎹骞朵互璇ヨ〃镙间腑鏁版嵁涓轰緥锛岄渶瑕佸湪A:B鍒椾腑镓惧埌涓嶤鍒楀瑰簲镄凚鍒楃殑鏁版嵁锛

❷ 濡备綍鍦‥XCEL涓镆ユ垒骞舵樉绀鸿〃镙间腑镄勬煇涓閮ㄥ垎鏁版嵁锛

鍙浠ュ湪EXCEL涓杈揿叆=IF(COUNTIF(Sheet2!A1:A6;A1);"鍖呭惈";"涓嶅寘钖")銆傚叾涓璖heet2!A1:A6鎸囩殑鏄绗浜屽紶鏁版嵁镓鍦ㄧ殑鍗曞厓镙艰寖锲达纴A1鏄绗涓寮犲崟鍏冩牸鏁版嵁锛堢洰镄勬槸镆ョ湅A1鍗曞厓镙兼暟鎹鏄钖﹀湪绗浜屽紶鏁版嵁琛ㄤ腑锛夈傚叿浣撶殑璁剧疆鏂规硶濡备笅锛

1銆佹墦寮涓涓狤XCEL鏂囦欢锛屽彲浠ョ湅鍒板綋鍓嶆湁Sheet1鍜孲heet2锛屼袱涓鏁版嵁銆