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.
2 Replies
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.
