Copy Values depending on Criteria to another worksheet

[gldurand]

Hi,

I have a worksheet with a number of columns. I want to be able to copy certain columns based on the criteria of other column EX:

Excel Workbook
	A	B	C	D	E
1	CDS Customer	ID	Health	Project Status	Project Name
Sheet1

I need a formula that would lookup if Column C is "RED", and take Column A-B values

I hope this is clear

Thanks my friends in Mr. Excel

 

[gldurand]

Additonal Information: I need to copy the row that meet the criteria of Column C to another worksheet

Thanks