EXCEL程式問題!!
2007-06-26 12:45 am
請問如果想在A1輸入號碼, 然後在B2出現資料, 但資料是在另一個表格內 (同一個檔案), 請問如何設置程式, 我已試=VLOOKUP, 但不成功, 請各位幫忙!!
回答 (2)
2007-06-27 6:03 am
✔ 最佳答案
假設資料在 Sheet1A欄為號碼, B欄為要尋找的資料
現在, 在 Sheet2 的 A1 輸入號碼, SHEET2 的 B1 輸入下列公式
B1 = VLOOKUP(A1, SHEET1!$A$1:$B$100,2,FALSE)
如要查的資料在 C欄 , 公式更改如下
B1 = VLOOKUP(A1, SHEET1!$A$1:$C$100,3,FALSE)
如此類推.........
2007-06-26 2:46 am
Every worksheet (表格) should have a name, say Sheet1, Sheet2 etc.
For example, if you want to refer a value of the cell C1 of Sheet2, you can type:
=Sheet2!C1
2007-06-26 15:04:19 補充：
Please specifiy your need in more detials before I can tell you more.
For example, if you want to refer a value of the cell C1 of Sheet2, you can type:
=Sheet2!C1
2007-06-26 15:04:19 補充：
Please specifiy your need in more detials before I can tell you more.
參考: Myself
收錄日期: 2021-04-12 21:45:45
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070625000051KK02761