Search and Find Between 2 sheets

[leebird]

Hello, I think this is an index match question. I have 2 sheets and I'm trying to bring in the value from sheet 2 to sheet 1.
Attached on sheet one in cell P2, I want to find the value in cell A2 on sheet 2 (in column E) and bring in the value from column C.

On my attached template, in sheet 1, I want to look for "123456" on sheet 2 column E and bring in the corresponding value from that row "103323" in column C onto sheet 1 column P.

I'm pretty sure this is an index match? Not sure what the formula would be.
Any assistance would be greatly appreciated

[alansidman]

=INDEX(Sheet2!$C$2:$C$28,MATCH(Sheet1!A2,Sheet2!$E$2:$E$28,0))