Help With Excel Formula across 2 sheets

[Amy-SB]

Hi, 

I have a sheet that lists companies I have contacted and want a sheet 2 to track when parcels are arriving from companies.  

So I want it to go something like 

If Colum C = Y then it copies the company name from Column A to Sheet 2 Column A

Hope this makes sense! 

[#2]

@Amy-SB 

I understand you want to list contacted companies in column A of sheet1 (header in A1 and company names in range A2:A25 for example). If you expect a parcel from a company listed in A10 you want to enter "Y" in cell C10 of sheet1.

=IF(sheet1!C2="Y",sheet1!A2,"")

Enter above formula in sheet2 in cell A2 and copy down to A25 (in this example).

All companies from column A of sheet1 with "Y" in the corresponding cell in column C of sheet 1 will be copied to the corresponding cell of column A in sheet2.