Excel 專家請入
Posted: Mon Jun 22, 2015 3:49 pm
呢個係味bug?
玩L死
玩L死
Page 1 of 1
Re: Excel 專家請入
Posted: Mon Jun 22, 2015 3:53 pm
NG G
Re: Excel 專家請入
Posted: Mon Jun 22, 2015 3:58 pm
formula should be like this
the lookup table assume there is something likes header
the lookup table assume there is something likes header
Re: Excel 專家請入
Posted: Mon Jun 22, 2015 11:19 pm
=vlookup(C10,$A$2:$B$4,2,FALSE)
missed last argument "false" and hence looking for similar instead of an exact match.
Moreover, without the "False" your list being lookup must be in ascending order
missed last argument "false" and hence looking for similar instead of an exact match.
Moreover, without the "False" your list being lookup must be in ascending order
Re: Excel 專家請入
Posted: Tue Jun 23, 2015 8:06 pm
I will try, you really profuxktional藥皇 wrote: =vlookup(C10,$A$2:$B$4,2,FALSE)
missed last argument "false" and hence looking for similar instead of an exact match.
Moreover, without the "False" your list being lookup must be in ascending order
Re: Excel 專家請入
Posted: Thu Jun 25, 2015 5:24 pm
用 vlookup 當然冇問題，但 Bill Gate 要個 lookup 來托七？
Re: Excel 專家請入
Posted: Fri Jun 26, 2015 1:31 am
Lookup 可以有 multiple vector, formula... vlookup/hlookup 只可以一個dckrell wrote: 用 vlookup 當然冇問題，但 Bill Gate 要個 lookup 來托七？
=LOOKUP(1,1/((case1)*(case2)*(case3)*...),[result vector])
上面係all match. 又可以下面 any case
=LOOKUP(1,1/((case1)+(case2)+(case3)+...),[result vector])
例.. 3 同 7 都return c