LOOKUP start and enddate

[prw79]

I have this formula: =LOOKUP(2;1/($D$2:$D$15<=G33)/($E$2:$E$15>=G33);$B$2:$B$15) to return a name when he/she is not available between to dates. Sometimes the given return date(G33) falls within multiple date ranges, resulting in more than 1 names. How can i make sure the formula gives multiple returns?
Thanks in advance.

 

[jasonb75]

If you want multiple results from a single formula in a single cell then you could try something on the lines of

=TEXTJOIN(", ";1;FILTER($B$2:$B$15;($D$2:$D$15<=G33)*($E$2:$E$15>=G33);"No match"))

 

[prw79]

If you want multiple results from a single formula in a single cell then you could try something on the lines of

=TEXTJOIN(", ";1;FILTER($B$2:$B$15;($D$2:$D$15<=G33)*($E$2:$E$15>=G33);"No match"))

Thanks! I will try this when possible. And what if i want the results to be in cells apart, lets say from a1 to a15?

 

[jasonb75]

Using just the FILTER function without TEXTJOIN will do that.