Forum Discussion

Bria Parker's avatar
Bria Parker
Copper Contributor
Jul 16, 2018
Solved

Excel- Referencing cells in another worksheet help needed

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!

Resources