PRAVEEN KUMAR RAI
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
hardik1087
89

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

From India, Ahmadabad
Ankita Bhavsar
4

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

From India, Ahmadabad
hardik1087
89

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, 245 views)
File Type: xls B.xls (22.5 KB, 193 views)

vrgajjar
6

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
jyotsna dahiya
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
Ankita Bhavsar
4

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

From India, Ahmadabad
anil.arora
663

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
pravinarakshe
Dear Praveen, Find attached excel file.
From India, Pune
Attached Files (Download Requires Membership)
File Type: xls X..xls (15.5 KB, 137 views)

ojos23
5

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

From India, Chennai
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.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.