Excel 2007 : Return all values from a column, based on multiple conditions

How is it possible to return all values from a column, based on 1 condition in one column and 5 conditions in the other column?

Column A - list of people, column B - ABC, column C - XYZ. I need to return all values from the column A if column B = "C" and column C = "X" and "Y" and "Z".

Please, advice... Thanks!