- 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!
View best response
That could be
Thank you Sergei, it worked perfectly!