Oct 05 2021 06:15 AM
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!
Oct 05 2021 07:13 AM
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.