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

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.

kwt890,

Welcome to ExcelFox.

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