I have two excel sheets.
The first excel sheet contains the following columns
The second file contains the following column
I want to move the DateofJoining column to the second file.
I have tried this umpteen number of times using VLOOKUP with no luck. The Date column in the second file after moving does not show dates however it shows some numbers. I want the exact dates not numbers.
I am attaching the file for your reference.
Please help me solve this Problem.
The first excel sheet contains the following columns
- SNO
- EmpName
- DateofJoining
- CardNo
- Alias
The second file contains the following column
- SNO
I want to move the DateofJoining column to the second file.
I have tried this umpteen number of times using VLOOKUP with no luck. The Date column in the second file after moving does not show dates however it shows some numbers. I want the exact dates not numbers.
I am attaching the file for your reference.
Please help me solve this Problem.
1 Attachment(s) [Login To View]