請問如何由Sheet1的tye 內容,自動轉移Sheet2?
code name tel tye
1 a1 tel1 kt
2 a2 tel2 tst
3 a3 tel3 kv
4 a4 tel4 nn
5 a5 tel5 kt
6 a6 tel6 tst
7 a7 tel7 kt
8 a8 tel8 nn
9 a9 tel9 kv
10 a10 tel10 kt
Sheet2 結果
kt kv nn tst
1 3 4 2
5 9 8 6
7
10
希望幫忙解決。謝謝。
更新1:
本人用SHEET2 A2=IF(ISERROR(VLOOKUP($A1,'Sheet1 (2)'!$A$2:$D$12,2,0)),"",VLOOKUP($A1,'Sheet1 (2)'!$A$2:$D$12,2,0)) Sheet2 結果 EXECLABCD 1ktkvnntst 20001000300040002 3 但在SHEET2 A3 用唔到, 請問是否要用ROW??
更新2:
[IMG]http://i1106.photobucket.com/albums/h371/lucky_jocky/672A547D540D.jpg[/IMG]