Help With Excel Formula across 2 sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2813003%22%20slang%3D%22en-US%22%3EHelp%20With%20Excel%20Formula%20across%202%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2813003%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20sheet%20that%20lists%20companies%20I%20have%20contacted%20and%20want%20a%20sheet%202%20to%20track%20when%20parcels%20are%20arriving%20from%20companies.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20want%20it%20to%20go%20something%20like%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Colum%20C%20%3D%20Y%20then%20it%20copies%20the%20company%20name%20from%20Column%20A%20to%20Sheet%202%20Column%20A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2813003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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! 

1 Reply

@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.