Trouble Listing all entries from one column into a cell if criteria are met

[mgeiger]

See screen shots - on the Calcs sheet, under Column A, I am trying to list all Entries from Column C of the Data Input sheet, where Column D in the Data Input sheet matches Column B in the Calcs sheet.

In this example, I want A16 on the Calcs sheet to say "CL, MH" because B2 in the Calcs sheet matches D2, D3, and D17 in the Data Input Sheet.

If it matters, Column C and Column D in the Data Input sheet are dropdown list entries.

Thanks

 

[Cubist]

In A7, try:

=TEXTJOIN(", ",,FILTER('Data Input'!$C$2:$C$100,('Data Input'!$D$2:$D$100=B7)*('Data Input'!$C$2:$C$100<>""),""))

 

[mgeiger]

That worked, Thanks!

This does populate the 'Data Input' Column A cells with duplicates. If you know of a way to alter the formula to remove duplicates, that would be even better. But this works well enough.

 

[mgeiger]

I just figured it out by incorporating the UNIQUE function. Thanks again.