Sir, I want to learn more about VLOOK UP & HLOOK UP IN EXCEL. Please help me to understand better use of its. Thanks Sunny Kumar
From India, Delhi
Acknowledge(0)
Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Sunny,
Basically, if you want to learn VLOOKUP and HLOOKUP, you need guidance from a knowledgeable person on the system. You cannot learn to use formulas in MS-Excel just by reading. However, I would like to explain the use of VLOOKUP and HLOOKUP.
VLOOKUP is used to retrieve data from one sheet to another based on specific criteria. To do this, you need two Excel sheets – one as the database and the other where you are using VLOOKUP or HLOOKUP.
I hope this information is helpful to you. Nevertheless, I recommend that you learn directly on the system with the guidance of an experienced individual.
Regards,
Sud
From India, Faridabad
Acknowledge(0)Amend(0)
Basically, if you want to learn VLOOKUP and HLOOKUP, you need guidance from a knowledgeable person on the system. You cannot learn to use formulas in MS-Excel just by reading. However, I would like to explain the use of VLOOKUP and HLOOKUP.
VLOOKUP is used to retrieve data from one sheet to another based on specific criteria. To do this, you need two Excel sheets – one as the database and the other where you are using VLOOKUP or HLOOKUP.
I hope this information is helpful to you. Nevertheless, I recommend that you learn directly on the system with the guidance of an experienced individual.
Regards,
Sud
From India, Faridabad
Acknowledge(0)Amend(0)
Not this section to be answered, mods please move this to knowledge or resource center section.
From India, Bangalore
Acknowledge(0)Amend(0)
26From India, Bangalore
Acknowledge(0)Amend(0)
Dear Sunny,
For VLOOKUP, you should have data in an Excel file where there is at least 1 column common in both sheets. Here are the steps to follow:
1. Select the common column and put a comma.
2. Then select the common column sheet from the other file and, with a click-and-shift, go up to the columns where you want to pull data and drag it up to the last row of this sheet.
3. Then put a comma.
4. Specify the number of columns.
5. Put a comma.
6. Enter "false".
7. Press Enter or Tab.
I hope this explanation is helpful.
Regards,
Kamlesh
From India, Indore
Acknowledge(0)Amend(0)
For VLOOKUP, you should have data in an Excel file where there is at least 1 column common in both sheets. Here are the steps to follow:
1. Select the common column and put a comma.
2. Then select the common column sheet from the other file and, with a click-and-shift, go up to the columns where you want to pull data and drag it up to the last row of this sheet.
3. Then put a comma.
4. Specify the number of columns.
5. Put a comma.
6. Enter "false".
7. Press Enter or Tab.
I hope this explanation is helpful.
Regards,
Kamlesh
From India, Indore
Acknowledge(0)Amend(0)
Dear Senior,
I need your help regarding paid leave records. Basically, I need a leave record format. Here is the paid leave data, and there are 1500 employees in my organization. Kindly provide me with a suitable format for leave so that I can maintain records for all 1500 employees. You can email me at niteshlucky@gmail.com.
Thank you.
From India, Delhi
Acknowledge(0)Amend(0)
I need your help regarding paid leave records. Basically, I need a leave record format. Here is the paid leave data, and there are 1500 employees in my organization. Kindly provide me with a suitable format for leave so that I can maintain records for all 1500 employees. You can email me at niteshlucky@gmail.com.
Thank you.
From India, Delhi
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Vlookup in Excel.xls