How To Use VLOOKUP Formula in Microsoft Excel | VLOOKUP in Excel | Excel VLOOKUP

Introduction

• The video demonstrates the process of using VLOOKUP in Excel to retrieve data from a table.

Types of VLOOKUP

• Two types of lookups:

  • Vertical Lookup: looks up data in a vertical direction (e.g., earthquakes).

  • Horizontal Lookup: data is arranged horizontally (e.g., depth dental loop).

Data Table Structure

• The table includes columns: Serial Number, Employee Name, Designation, Basic Salary, Net Salary.

• Sample data is added for demonstration.

Performing VLOOKUP

• Steps to apply VLOOKUP:

  1. Enter "=VLOOKUP" with parameters:

     • Lookup Value: Serial number.

     • Table Array: the complete selection of the table.

     • Column Index Number: specify the column for the output value.

     • Range Lookup: TRUE/FALSE (use FALSE for exact match).

  2. Example: Enter a serial number to find the associated employee name.

Example Demonstration

• Selected Serial Number 6 to retrieve information.

• Formula input:

  • =VLOOKUP(Serial Number Cell, Table Range, Column Index, FALSE).

• Returns Employee Name for Serial Number 6: "Suman Roy".

Retrieving Net Salary

• To find Net Salary:

  • Repeat the VLOOKUP process for the Net Salary column, replacing the column index accordingly.

• Example provides the Net Salary for Serial Number 6.

Conclusion

• VLOOKUP allows retrieval of data vertically from Excel tables.

• By entering serial numbers, associated data can be easily accessed.