|
Junior Member
您的住址: 修得文武藝, 賣與帝王家
文章: 770
|
A B C
1|a 1
2|b 2
3|c 3
4|b 4 "=VLOOKUP(INDIRECT("C[-2]",0),$A$1:$B$3,2)"
5|b 5 "=VLOOKUP(INDIRECT("C[-2]",0),$A$1:$B$3,2)"
6|c 6 "=VLOOKUP(INDIRECT("C[-2]",0),$A$1:$B$3,2)"
7|c 7 "=VLOOKUP(INDIRECT("C[-2]",0),$A$1:$B$3,2)"
__________________
|