Vlookup Copy Error - unable to copy same formula to obtain DOJ

Dear Excel Experts, In Sheet 2, vlookup formula has been applied to obtain emp codes from sheet 1. However, unable to copy same formula to obtain DOJ.
Please find sheet attached and help to resolve.

please give the details of the other sheet from were you are trying to capture details

Hi please find attached.
Thanks and Regards,
Akash Sharma

You are using wrong table reference for lookup. As you are doing vlookup on the basis of Emp code, so your table should start from Emp code column and include DOJ column in reference table. Lookup table's first column should include the value based on which use are doing search. Correct formula would be :
=vlookup(C2,Sheet1!$C$2:$D$51,2,0)

okay thanks.
Thanks and Regards,
Akash Sharma