Struggling with VLOOKUP: How Can I Copy the Formula to Get Date of Joining?

Dear Excel Experts,

In Sheet 2, a VLOOKUP formula has been applied to obtain employee codes from Sheet 1. However, I am unable to copy the same formula to obtain the Date of Joining (DOJ).

Please find the sheet attached and help me to resolve this issue.

You are using the wrong table reference for the lookup. Since you are performing a VLOOKUP based on the Emp code, the table should start from the Emp code column and include the DOJ column in the reference table. The lookup table's first column should contain the value on which you are performing the search. The correct formula would be:

=VLOOKUP(C2, Sheet1!$C$2:$D$51, 2, 0)