Forum Discussion
XLOOKUP produces a drop-down list
Hello,
Do you know if it is possible to return a drop-down list if the result of my XLOOKUP in my database returns several duplicates?
If the search result is unique, it will only return this data.
Thank you.
XLOOKUP only returns the first matching value.
You can use FILTER to return all values matching criteria. You can combine it with TEXTJOIN to display all matching values in a single cell, but it won't be a drop-down list.
To create a drop-down list with matching values would require VBA.
- Thank you for your reply. I will use FILTER and TEXTJOIN for this situation.
