Index Match with multiple results using Textjoin

[bhsoundman]

Hi Everyone,

Thanks in advance for any help I may get. I have a working index match formula with one drawback. If I get multiple results, currently only the first result takes priority. I'd like to show all returned results in the same cell, and I see many posts about using textjoin to do it. I'm having a difficult time integrating that function into my current working formula. Here's what I have:

{=INDEX($A:$A,MATCH(1,(($F32=$D:$D&$E:$E)*(G$29>=$B:$B)*(G$29<=$C:$C)),0))}

Any ideas?

Thanks so much!!

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[bhsoundman]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks, I updated my profile. I'm on Office 365 for Mac version 16.57

 

[Fluff]

Thanks for that, how about

=TEXTJOIN(",",,FILTER($A$2:$A$100,(($D$2:$D$100=$F32)+($E$2:$E$100=$F32))*($B$2:$B$100<=G$29)*($C$2:$C$100>=G$29),""))

 

[bhsoundman]

Thanks for that, how about

=TEXTJOIN(",",,FILTER($A$2:$A$100,(($D$2:$D$100=$F32)+($E$2:$E$100=$F32))*($B$2:$B$100<=G$29)*($C$2:$C$100>=G$29),""))

This works PERFECTLY!! Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.