Vlookup: Strange Problem - Xls Download

I have two excel sheets.

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.
16th December 2010 From India, Delhi

Attached Files (Download Requires Membership)

vlookup_problem.xls (15.5 KB, 484 views)

I do not know what you want to do. Why not just hight light the column and then copy and paste it to the second sheet. Also click on the strings for Vlookup at the right of this box.
Have a nice day.
Simhan
17th December 2010 From United Kingdom

hi Kamalarya,
Pls go thro this url vlookup Excel Function Tutorial Example how to formula Help guide
You will find lot of excel tutorials with examples.
Shiva
17th December 2010 From India, Madras

hi kamalarya,
it's simple.. after doing vlookup. just select all the nos over ther and right click it... select format column from ther. select date in that tab and click on the format of date u want to have them ... that's it.
17th December 2010 From India, Pondicherry

hi
I donno whether ou've got the reply for this concern you have had
But in the 2nd sheet you can format the cells with Date.
process -
1. After vlookup in the 2nd sheet please select the 2nd column and right click the mouse
2. In the pop up menu / task bar please click on Format cells
3. In the number tab click opn date and select the format date type you are looking at and click on Ok
4. this solves your concern
Regards
Kranthi Kiran
23rd December 2010 From India, Mumbai