Concatenate Two Or Multiple Columns In To One Based On Multiple Criteria

[kwt890]

NOTE: This message was move from Rick Rothstein's Corner to this sub-forum to increase visibility

Hey Rick/Anybody

I'm trying to return multiple text values in one column into a single cell only if it meets 4 criteria (i.e. region = "Asia") + ("complete)+(Internal)+(=L9 *** where L9 is the month input). After all these conditions are met in their respective columns I want to search through another column (let's say C4:C2000 is "name") and return every name into one single cell on a different sheet, delineated by a ";" if possible. I'm so frustrated with this! Been using index(etc,Match(1,)0) but that will only give me one value. Can someone please help? Rick you seem to be the go to for things like this.

[Excel Fox]

kwt890,

Welcome to ExcelFox.

Can you post a sample workbook, so that one of the we can have a look