SOLVED

Excel- Referencing cells in another worksheet help needed

%3CLINGO-SUB%20id%3D%22lingo-sub-216083%22%20slang%3D%22en-US%22%3EExcel-%20Referencing%20cells%20in%20another%20worksheet%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216083%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20referencing%20from%20one%20sheet%20in%20Excel%20to%20another%20in%20the%20attached%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%20has%20the%20industry%20for%20each%20unique%20Project_ID%20and%20their%20respective%20industry.%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%202%20has%20a%20a%20count%20of%20each%20Project_ID%20with%20the%20empty%20industry%20column%20I%20need%20to%20fill%20by%20referencing%20from%20sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20need%20to%20reference%20the%20single%20industry%20from%20sheet%201%20to%20each%20instance%20of%20the%20Project_ID%20on%20sheet%202%20(I%20need%20to%20fill%20in%20the%20%22Industry%22%20column%20in%20sheet%20two).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20snippet%20from%20a%20much%20larger%20file%2C%20so%20I%20need%20to%20use%20a%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figure%20I%20have%20to%20do%20a%20Vlookup%2C%20but%20I'm%20not%20sure%26nbsp%3Bhow%20to%20do%20that%20for%20this%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advanced%20for%20your%20help%20everyone!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-216083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216252%22%20slang%3D%22en-US%22%3ERe%3A%20Excel-%20Referencing%20cells%20in%20another%20worksheet%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216252%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Sergei%2C%20it%20worked%20perfectly!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216088%22%20slang%3D%22en-US%22%3ERe%3A%20Excel-%20Referencing%20cells%20in%20another%20worksheet%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216088%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Bria%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(INDEX(Sheet1!B%3AB%2CMATCH(A2%2CSheet1!A%3AA%2C0))%2C%22%22)%3C%2FPRE%3E%0A%3CP%3Eand%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I need help referencing from one sheet in Excel to another in the attached spreadsheet. 

 

Sheet 1 has the industry for each unique Project_ID and their respective industry. 

Sheet 2 has a a count of each Project_ID with the empty industry column I need to fill by referencing from sheet 1.

 

So I need to reference the single industry from sheet 1 to each instance of the Project_ID on sheet 2 (I need to fill in the "Industry" column in sheet two). 

 

This is a snippet from a much larger file, so I need to use a formula. 

 

I figure I have to do a Vlookup, but I'm not sure how to do that for this data. 

 

Thank you in advanced for your help everyone!

2 Replies
Highlighted
Solution

Hi Bria,

 

That could be

=IFERROR(INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)),"")

and attached

Highlighted

Thank you Sergei, it worked perfectly!