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
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
From India, Ahmadabad
89Please 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
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
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
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
From India, Ahmadabad
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
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
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
From India, Ahmadabad
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
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
Sorry but this is a basic thing and everybody must have known about it
From India, Gurgaon
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Vlookup&hlookup .xls