Anil.arora
Administration Head
Hardik1087
Compensation Mgt, Performance Appraisal &
Vrgajjar
Manager Human Resource
Ankita Bhavsar
Manager - Hr
Pravinarakshe
Human Resource Management
+3 Others

Dear seniors I found error whenever i use vlookup command so please provide me exel sheet with used these commands Regards Praveen
21st May 2012 From India, New Delhi
Hi Praveen,
Please look after the below link.
https://www.citehr.com/397346-excel-...ml#post1810329
If you have any problem feel free to ask.
Regards,
Hardik
21st May 2012 From India, Ahmadabad
Dear Praveen,
whenever you have to match the column records of two sheets, Vlookup can be useful for the same. And it can be use as follow:
Sheet 1: Column A
Clmn.A: Name Clmn B:Age
A =VLOOKUP(A1:C:3,sheet2!A1:C3,3,0)
B
C
Sheet 2
Clmn.A: Name Clmn B:BOD ClmnC:Age
C
B
A
Explanation=VLOOKUP(A1:C:3,sheet2!A1:C3,3,0)
A1:C3=Existing Sheet range, based on which detail, require data should get
Sheet2: select the sheet from where you need to fetch the data
A1:C3: Entire Range from where data should fetch=A=Name,B-DOB,C-Age)
3: Number of column where the data mention (i.e Age)
0: Default
It's confusing but you may try.
Thanks
Ankita
22nd May 2012 From India, Ahmadabad
Hi Jyotsna Here I attached file about Vlookup. So kindly find the enclosed attachment. A is old file we have taken data from A file to B file by Vlookup. Regards, Hardik Bhavsar Hr Coordinator
22nd May 2012 From India, Ahmadabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls A.xls (19.0 KB, 220 views)
File Type: xls B.xls (22.5 KB, 175 views)

Ankita, If, you know this formula then plz guide me. I don’t understand how to make this mormula and how to use this formula.
23rd May 2012 From India, Ahmadabad
Kindly help me what is the eligiblity of PhD as i m doing MBA in Marketing now i m Planning to do PhD please Guide me in which subject can i do phD or tell me some good insitute name of PhD and...
23rd May 2012 From India, Delhi
Hi Mr. Gajjar,
As I have mentioned, it can be very helpful while cross check the detail and reconfirm the work. I had well tried to explain in my previous post so try to get it understand from it as it's difficult to make it understand in written.
Thanks
Ankita
23rd May 2012 From India, Ahmadabad
Why dont you go to MS EXCEL HELP first as there is every thing available from where you can start learning and using.. Later you can seek help on this from others
Sorry but this is a basic thing and everybody must have known about it
23rd May 2012 From India, Gurgaon
Dear Praveen, Find attached excel file.
23rd May 2012 From India, Pune

Attached Files
Membership is required for download. Create An Account First
File Type: xls X..xls (15.5 KB, 100 views)

Dear All,
Don't get confuse with the V look up and H loop up we have to updated lot of new software which used for calculation so please use that software it will help you lot and this will be my advise.
Don't be conservative.
Regards,
Rahul
28th December 2012 From India, Chennai
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™