Excel 專家請入

[v234567]

呢個係味bug?

玩L死

[alexchrome]

NG G

[trytrysin]

formula should be like this
the lookup table assume there is something likes header

excel.jpg

[藥皇]

=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

[v234567]

=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

I will try, you really profuxktional

[dckrell]

用 vlookup 當然冇問題，但 Bill Gate 要個 lookup 來托七？

[藥皇]

用 vlookup 當然冇問題，但 Bill Gate 要個 lookup 來托七？

Lookup 可以有 multiple vector, formula... vlookup/hlookup 只可以一個

=LOOKUP(1,1/((case1)*(case2)*(case3)*...),[result vector])

上面係all match. 又可以下面 any case

=LOOKUP(1,1/((case1)+(case2)+(case3)+...),[result vector])


例.. 3 同 7 都return c