I met this in my job. my solution: [#4423021@0 -ROLIA.NET 相约加拿大网上社区 之 枫下论坛 & 枫下部落, 枫下论坛主坛 ]
I met this in my job. my solution:
by
fedept
(fedept)
at
2008.4.29 13:31
(#4423021@0)
chose the whole colum as your range to search. like this.VLOOKUP(A:A,A:B,2,FALSE)
don't add the number of the colum like A1:B1000.
Ps. If columb B have multiple value ColumnA ,you will get the fist value of column B by using vlookup. hope it helps.
B 2 B 2(=VLOOKUP(C:C,A:B,2,FALSE)
B 3 B 2(=VLOOKUP(C:C,A:B,2,FALSE)
B 5 B 2(=VLOOKUP(C:C,A:B,2,FALSE)