How To Use Vlook & Hlookup Commands - XLS Download - CiteHR
Anil.arora
Administration Head
Hardik1087
Compensation Mgt, Performance Appraisal &
Vrgajjar
Manager Human Resource
Ankita Bhavsar
Manager - Hr
Pravinarakshe
Human Resource Management
+3 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Dear seniors I found error whenever i use vlookup command so please provide me exel sheet with used these commands Regards Praveen
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

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

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

Attached Files
Membership is required for download. Create An Account First
File Type: xls A.xls (19.0 KB, 227 views)
File Type: xls B.xls (22.5 KB, 179 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.
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...
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

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

Dear Praveen, Find attached excel file.

Attached Files
Membership is required for download. Create An Account First
File Type: xls X..xls (15.5 KB, 103 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

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™