|
||
|
Junior Member
  
加入日期: Sep 2001 您的住址: ....
文章: 735
|
Google spreadsheet 或是 ms excel 函數問題
很久沒碰這種東西了 弄不出來 想說來問問應該有人會
我需要做一個功能 在I14輸入人名，J14會自動區上面的A欄找字串，有符合的就return那一列的D欄位數值 這個功能要怎麼寫呢?
__________________
as I can't feel at home in this world anymore |
|||||||
2018-11-23, 10:26 PM
#1
|
|
|
Golden Member
 
加入日期: Apr 2003
文章: 2,592
|
J12函數
=VLOOKUP(I12,$A$2:$D$7,4,FALSE) |
||
|
2018-11-24, 12:00 AM
#2
|
|
|
Junior Member
加入日期: Sep 2001 您的住址: ....
文章: 735
|
沒想到這麼快就有答案 感謝
__________________
as I can't feel at home in this world anymore |
|
2018-11-24, 11:32 AM
#3
|
|
