Forum Discussion
Solved
Setting up Searchable Dropdown list (WITHOUT Filter function)
Hi All, I'm trying to set up a searchable dropdown list. It'll effectively be for searching for clients by name. I am trying to avoid using the filter function as not everyone will access th...
The sample file downloaded from the video is working without any problem with me. The very interesting thing is when I used the same formular within my own Excel file, it did not work properly.
The issue is at Named Reference Formula column. I have to changed it into following and drag it down:
=IFNA(INDEX(ProductList[Product],MATCH(ROW($D$1:D1),ProductList[Workings],0)),"")
Now here comes the more interesting part. If I replace my version of the above formula into the sample Excel file, it did not work!
Weird! But hope this would help you a bit.
- Thank you. I do need to revisit this shortly, but also notice that a built in version is in beta. So am thinking I might wait for that.