Dear seniors I found error whenever i use vlookup command so please provide me exel sheet with used these commands Regards Praveen
From India, New Delhi
Administration & Liaisoning Head
Compensation Mgt, Performance Appraisal &
Manager, Human Resources
Ankita Bhavsar
Manager - Hr
Human Resource Management
+3 Others

Hi Praveen,
Please look after the below link.
If you have any problem feel free to ask.

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)
Sheet 2
Clmn.A: Name Clmn B:BOD ClmnC:Age
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.

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
From India, Ahmadabad

Attached Files (Download Requires Membership)
File Type: xls A.xls (19.0 KB, 240 views)
File Type: xls B.xls (22.5 KB, 189 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.
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...
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.

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

From India, Gurgaon
Dear Praveen, Find attached excel file.
From India, Pune

Attached Files (Download Requires Membership)
File Type: xls X..xls (15.5 KB, 115 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.

From India, Chennai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server