Lookup for multiple matches - 2 Alternatives

Download working file πŸ‘ˆπŸ‘¨‍πŸ’»

Here I am going to show you how we can get multiple matches of a lookup value from a list.

1st Alternative

FILTER Formula


2nd Alternative

TEXTJOIN and IF Formula



Download working file πŸ‘ˆπŸ‘¨‍πŸ’»

Thank You!