Excel- Referencing cells in another worksheet help needed

[Bria Parker]

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 · Accepted solution]

Hi Bria,

That could be

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

and attached

[#3]

Thank you Sergei, it worked perfectly!