Need help. If A:2 equals anything in A:A in another sheet, need value of a different cell.

I am trying to write a formula that will show the value of a different cell based on the logic of separate cells and columns. e.g. If 'sheet 1' A2 = any cell in 'sheet 2' A:A, show the value of a different cell in the same row as the A2 equivalent. In this instance, I need the formula cell to display the value of the cell in 'sheet 2' column C for the same row that contains the 'sheet 2' A:A cell equivalent of 'sheet 1' A2. I hope this makes sense to someone. I'm banging my head against the wall here.

=IFERROR(INDEX(sheet2!$C$2:$C$1000, MATCH(A2, sheet2!$A$2:$A$1000,0)),"")