Copying specific rows to new worksheet

I have data in columns A:C in Sheet 1 where column C states either "valid" or "invalid." I want to copy all the data where column C = "Invalid" to Sheet2

I tried the following Array formula in Sheet2;
{=IF(Sheet1!$C1:$C$500 ="Invalid",Sheet1!A1:C500,"")}

but that leaves blank spaces in all the rows that were valid. I'm missing something here. Any help? Thanks in advance

ChemistB

Does this need to be moved to the Excel Programming folder? Thanks

ChemistB