Lookup Find 一問, 已有公式, 但睇唔明

條式係上網搵架
紅色字既係我唔明既野~
我想做既效果, 係咪只有哩條公式?
有無D更易理解架? 八下而已

Question for HKEPC 3.jpg (83.74 KB)

Question for HKEPC 3.jpg

回覆 1# duckedog

https://stackoverflow.com/questi ... ty-cell-in-a-column

"Using following simple formula is much faster"

講得幾好, 可以參考一下

TOP