[算表] 依A欄1的位置取B欄的值，結果顯示C欄
軟體:excel
版本:97-2003
A B C
1 3 3
2 1 3
3 3
4 3
5 7 3
6 7
7 7
8 10 7
9 7
10 1 10
11 13 10
依A欄1的位置取B欄的值，結果顯示C欄
請問公式如何寫?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.248.19.151
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1463045141.A.D8A.html
→
05/12 18:11, , 1F
05/12 18:11, 1F
※ 編輯: jie123 (60.248.19.151), 05/12/2016 18:44:19
→
05/12 18:45, , 2F
05/12 18:45, 2F
→
05/12 23:11, , 3F
05/12 23:11, 3F
→
05/12 23:41, , 4F
05/12 23:41, 4F
→
05/12 23:41, , 5F
05/12 23:41, 5F
→
05/12 23:44, , 6F
05/12 23:44, 6F
→
05/12 23:44, , 7F
05/12 23:44, 7F
→
05/12 23:48, , 8F
05/12 23:48, 8F
→
05/12 23:49, , 9F
05/12 23:49, 9F
→
05/12 23:49, , 10F
05/12 23:49, 10F
→
05/12 23:51, , 11F
05/12 23:51, 11F
→
05/12 23:52, , 12F
05/12 23:52, 12F
→
05/12 23:55, , 13F
05/12 23:55, 13F
→
05/13 12:37, , 14F
05/13 12:37, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
