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)
Understanding VLOOKUP and HLOOKUP in Excel
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 Functionality
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 Functionality
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)
Steps to Use VLOOKUP in Excel
For VLOOKUP, you should have data in an Excel file where there is at least one 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 one 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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Functions Dictionary.xls
Advanced Excel 2003.pdf