- last edited on
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!
07-16-2018 08:35 AMSolution
That could be