Excel Help Needed: How Can I Better Understand VLOOKUP and HLOOKUP Functions?

Sir,

I want to learn more about VLOOKUP and HLOOKUP in Excel. Please help me understand their better use.

Thanks,
Sunny Kumar

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

Not this section to be answered, mods please move this to knowledge or resource center section.

---

Not this section needs to be answered. Mods, please move this to the knowledge or resource center section.

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