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.
From India, Delhi
8The 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.
From India, Delhi
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
From United Kingdom
Have a nice day.
Simhan
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
From India, Madras
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
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.
From India, Pondicherry
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.
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
From India, Mumbai
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
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Vlookup in Excel.xls
Excel Pivot Tables Recipe Book - A Problem-Solutio n Approach (2006) - allbooksfree.tk .pdf