Forum Discussion
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 ha...
Hi Bria,
That could be
=IFERROR(INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)),"")
and attached
Hi Bria,
That could be
=IFERROR(INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)),"")
and attached
Thank you Sergei, it worked perfectly!
