Excel。在C1中输入产品名称，怎样做才能在输入名称后自动跳转到B列中相同的产品名称所在的单元格？
\u6211\u60f3\u5728A\u5217\u8f93\u5165\u4ea7\u54c1\u7f16\u53f7\uff0cB\u5217\u8f93\u5165\u4ea7\u54c1\u540d\u79f0\uff0c\u4ee5\u540e\u53ea\u8981\u4e00\u8f93\u5165A\u5217\u7684\u4ea7\u54c1\u7f16\u53f7\uff0cB\u5217\u5c31\u53ef\u4ee5\u81ea\u52a8\u51fa\u73b0\u4ea7\u54c1\u540d\u9700\u8981\u6709\u4e00\u4e2a\uff0c\u4ea7\u54c1\u7f16\u53f7\u548c\u540d\u79f0\u7684\u660e\u7ec6\u8868\uff0c\u5047\u8bbe\u5728SHEET2\u7684A\u548cB\u5217\uff1b\u5728\u64cd\u4f5c\u8868\u4e2d\u4e5f\u662fA\u548cB\u5217\uff0c\u5728B2\u7528\u516c\u5f0f\uff1a
=VLOOKUP(A1,sheet2!A:B,2,0)
\u4e0b\u62c9\u3002
\u5728D:E\u5217\u5efa\u7acb\u4ea7\u54c1\u548c\u5355\u4ef7\u7684\u5bf9\u5e94\u8868\uff0c\u7136\u540e\u5728B2\u5355\u5143\u683c\u8f93\u5165\u4ee5\u4e0b\u516c\u5f0f\uff0c\u5e76\u5411\u4e0b\u586b\u5145\u516c\u5f0f
=IF(A2="","",VLOOKUP(A2,D:E,2,0))
\u516c\u5f0f\u8868\u793a\uff1a\u5982\u679cA2\u4e3a\u7a7a\uff0c\u5c31\u7559\u7a7a\uff1b\u5728D\u5217\u7cbe\u786e\u5339\u914d\u4e0eA2\u76f8\u540c\u7684\u5355\u5143\u683c\uff0c\u5e76\u8fd4\u56de\u5bf9\u5e94\u7b2c2\u5217\uff08E\u5217\uff09\u7684\u6570\u636e\u3002
\u8be6\u89c1\u9644\u56fe
在D1输入公式：
=HYPERLINK("#B"&MATCH(C1,B:B,),"跳转")
公式还可以加入防错判断，当C1为空白或C1的值不存在于B列中时，公式返回空白值，以上公式返回#N/A的错误值。
=IF(COUNTIF(B:B,C1),HYPERLINK("#B"&MATCH(C1,B:B,),"跳转"),"")
我把文件传上来，请点击这回答右下角绿色的“点击下载”按钮，下载文件看看效果。
你在C2中输入公式：
=HYPERLINK("#"&ADDRESS(MATCH($C$1,$B:$B),2,4)&"","跳转")
在C1中输入产品名称，然后点C2单元格就会跳转到相应的单元格中去。
绛旓細鍦―1杈撳叆鍏紡锛=HYPERLINK("#B"&MATCH(C1,B:B,),"璺宠浆")鍏紡杩樺彲浠ュ姞鍏ラ槻閿欏垽鏂紝褰揅1涓虹┖鐧芥垨C1鐨勫间笉瀛樺湪浜嶣鍒椾腑鏃讹紝鍏紡杩斿洖绌虹櫧鍊硷紝浠ヤ笂鍏紡杩斿洖#N/A鐨勯敊璇笺=IF(COUNTIF(B:B,C1),HYPERLINK("#B"&MATCH(C1,B:B,),"璺宠浆"),"")鎴戞妸鏂囦欢浼犱笂鏉ワ紝璇风偣鍑昏繖鍥炵瓟鍙充笅瑙掔豢鑹茬殑鈥滅偣...
绛旓細C1鍏紡锛=OFFSET(A$1,10*INT((ROW()-1)/10),) 涓嬫媺 璇曡瘯B1鐢ㄤ笅闈㈢殑鍏紡锛=LOOKUP(9^9,A$1:A1)涓嬫媺
绛旓細1銆佸湪宸ヤ綔琛⊿HEET1鐨凙鍒涓緭鍏鍨嬪彿锛屽湪B鍒椾腑瀵瑰簲鐨勫崟鍏冩牸鑷姩鏄剧ず鍑鸿浜у搧鐨勫崟浠枫2銆佸厛瑕佹柊寤轰竴涓伐浣滆〃锛屾宸ヤ綔琛ㄧ敤鏉ュ瓨鏀惧瀷鍙蜂笌鍗曚环鐨勬暟鎹傛瘮濡傦紝鏂板缓宸ヤ綔琛⊿HEET2銆3銆佸湪宸ヤ綔琛⊿HEET2鐨凙鍒楀拰B鍒椾腑杈撳叆鍨嬪彿涓庡崟浠锋暟鎹4銆佽繖涓姝ュ仛濂藉悗锛岄偅涔堬紝鎴戜滑杩斿洖鍒癝HEET1宸ヤ綔琛紱閫変腑B鍒椼5銆佺劧鍚庯紝鍦...
绛旓細4銆佽緭鍏ュ叕寮忓悗锛屽洖杞︾‘瀹氥5銆佸鏋滆繕闇瑕佹樉绀哄叾浠栭」锛岀户缁緭鍏ュ叕寮=VLOOKUP锛圓2,Sheet2!A:C,3,0)銆6銆佽緭鍏ュ叕寮忓悗锛屽洖杞︾‘璁ゃ7銆侀兘杈撳ソ鍏紡鍚庯紝鍦ㄧ紪鐮涓緭鍏鍨嬪彿锛屽氨浼氳嚜鍔ㄦ樉绀浜у搧鍚嶇О浜嗐
绛旓細Set sh = Sheets("浜у搧搴").Range("B:B")Set d = sh.Find(.Value, LookIn:=xlValues, Lookat:=xlWhole)If Not d Is Nothing Then .Offset(0, 1).Value = d.Offset(0, 1).Value .Offset(0, -1).Value = d.Offset(0, -1).Value Else .Offset(0, 1).Value = "鎵句笉鍒拌...
绛旓細璁続1涓鍚嶇О锛孊1涓哄崟浠凤紝C1涓烘暟閲忥紝D1涓洪噾棰 B1鍗曞厓鏍杈撳叆锛=IF(A1="鏉ㄦ湪5*10*400",30,"")D1鍗曞厓鏍艰緭鍏ワ細=B1*C1 杩欐牱灏辫浜嗭紝褰撲綘A1鍗曞厓鏍艰緭鍏:鏉ㄦ湪5*10*400鏃禕1鑷姩浼氬彉鎴30锛孋1鍗曞厓鏍艰緭鍏ユ暟閲忔椂,D1鑷姩璁＄畻浠锋牸浜
绛旓細鍥句腑{=VLOOKUP(A2,鍗曚环!A2:B8,2,FALSE),} 鈥滃崟浠封濓細琛ㄧず鍦ㄤ箣鍓嶆湁涓悕瀛楀彨鍗曚环鐨勫伐浣滆〃锛屽唴瀹瑰寘鎷骇鍝佸悕绉板拰鍗曚环銆傚湪鏌ヨ琛ㄤ腑鍙杈撳叆浜у搧鍚嶇О璺熸暟閲忓氨鍙互浜嗐備綘鏈夎鍗曡〃锛屽彲浠ユ妸鐩稿叧鏁版嵁澶嶅埗鍑烘潵锛岀矘璐村湪鏌ヨ琛ㄧ浉搴旀爮鐩閲灏卞彲浠ヤ簡銆備豢鐓т笅鍒朵綔浣犺嚜宸辩殑鏌ヨ琛ㄥ惂锛屾煡璇㈣〃渚嬪瓙濡傚浘鎵绀猴細...
绛旓細鍦ㄥ崟鍏冩牸A2涓緭鍏モ002鈥濓紝B2涓緭鍏モ滀笁鏄焫xxx鈥濓紱鍦ㄥ崟鍏冩牸A3涓緭鍏モ003鈥濓紝B3涓緭鍏モ滄懇鎵樼綏鎷夆濓紱鈥︹鍦–1涓緭鍏鍏紡锛氣=vlookup(d1,a:b,2,false)鈥濄傚彧瑕佷綘鍦―1鍗曞厓鏍间腑杈撳叆鈥001鈥濓紝鎸変笅鍥炶溅閿悗锛孋1鍗曞厓鏍间腑鐨勫叕寮忓氨浼氭樉绀衡滆鍩轰簹5800鈥濓紱杈撳叆鈥002鈥濓紝鏄剧ず鈥滀笁鏄焫xxx鈥濓紱杈撳叆鈥003鈥濓紝...
绛旓細=if($a1="","",index(sheet1!$A:$A,match($b1,sheet1!$B:$B,)))C1杈撳叆 =if($a1="","",index(sheet1!$C:$C,match($b1,sheet1!$B:$B,)))D1杈撳叆 =if($a1="","",index(sheet1!$D:$D,match($b1,sheet1!$B:$B,)))涓嬫媺鍏紡銆傝繖鏍锋柊琛ㄧ殑A鍒楀彲浠杈撳叆浜у搧鍚嶇О浜 ...
绛旓細鍦―:E鍒楀缓绔浜у搧鍜屽崟浠风殑瀵瑰簲琛紝鐒跺悗鍦˙2鍗曞厓鏍杈撳叆浠ヤ笅鍏紡锛屽苟鍚戜笅濉厖鍏紡 =IF(A2="","",VLOOKUP(A2,D:E,2,0))鍏紡琛ㄧず锛氬鏋淎2涓虹┖锛屽氨鐣欑┖锛涘湪D鍒楃簿纭尮閰嶄笌A2鐩稿悓鐨勫崟鍏冩牸锛屽苟杩斿洖瀵瑰簲绗2鍒楋紙E鍒楋級鐨勬暟鎹傝瑙侀檮鍥
