Leung Sir, question about the method of wildcard search, if you input only pe in H7, the result is only (peach, 18).Data shows that we also has (pear, 48). This method will show only the first result of the search. If we need a better xlookup function, I am sure that will be more complicate like using index, match, array or need to populate in more rows? I am not good at that, if you have time, maybe you can give us a better way to return multiple result. thanks
![Excel Tips: 用輸入 [ Formula ] 方法, 助你做條件格式化. ✅彈性增大 ✅資料清晰.](http://i.ytimg.com/vi/s6kmcsX1l3U/mqdefault.jpg)
![Excel Tips: 用輸入 [ Formula ] 方法, 助你做條件格式化. ✅彈性增大 ✅資料清晰.](/img/tr.png)
![Excel入門 XLookUp 5分鐘懶人包教學[廣東話] [點CC看中文字幕][附12星座挑戰題] #Excel入門 #Excel教學廣東話 #ExcelDictionary](/img/n.gif)
好有用👍
多謝收看
👍👍👍
Thanks
👍好用
多謝收看
Leung Sir, question about the method of wildcard search, if you input only pe in H7, the result is only (peach, 18).Data shows that we also has (pear, 48). This method will show only the first result of the search. If we need a better xlookup function, I am sure that will be more complicate like using index, match, array or need to populate in more rows? I am not good at that, if you have time, maybe you can give us a better way to return multiple result. thanks
If peach is not the target item, user may input more characters to narrow down the scope of wildcards search. It is the idea of wildcards search.
請問如果我想係 #4EXAMPLE 逆向SEARCH
即係我SEARCH $3924 出 APPLE 同 JAN 或者 如果多個一個係$3924 就LIST晒全部出黎
可以點做?
因出外旅遊，要11/18 號才可安排時間研究你嘅提問。謝謝