Be a pro in LOOKUP function in Excel.pptx

This is a comprehensive presentation that summarizes how to be a pro in LOOKUP function in excel

1. Mastering VLOOKUP Function in Excel INTRODUCTION

2. TYPES OF LOOKUPS EXCEL VLOOKUP: Stands for Vertical Lookup. It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. This function is commonly used for looking up information in a table vertically. HLOOKUP: Stands for Horizontal Lookup. Similar to VLOOKUP, it searches for a value in the top row of a table and returns a value in the same column from a specified row. This function is used for looking up information horizontally. INDEX-MATCH: This is a combination of the INDEX and MATCH functions. INDEX returns the value of a cell in a table based on the row and column number, while MATCH returns the relative position of an item in an array. Together, these functions can perform vertical and horizontal lookups more flexibly and efficiently than VLOOKUP or HLOOKUP. XLOOKUP: Introduced in later versions of Excel (2019 and Microsoft 365), XLOOKUP is a versatile lookup function that can search vertically and horizontally in a table. It offers enhanced features such as the ability to return an array of matching values, handle errors more efficiently, and perform approximate and exact matches without the need to sort data.

3. WHAT IS VLOOKUP VLOOKUP is a powerful Excel function used to search for a value in the first column of a table and return a corresponding value in the same row from another column. Purpose: VLOOKUP simplifies data retrieval and analysis tasks by eliminating the need for manual searching and matching

4. Syntax and Parameters Syntax =VLOOKUP( lookup_value , table_array , col_index_num , [ range_lookup ]) Parameters: lookup_value : The value to search for in the first column of the table. table_array : The range of cells that contains the data to be searched. col_index_num : The column number in the table_array from which to retrieve the value. range_lookup : Optional parameter specifying whether to find an exact or approximate match. (TRUE or FALSE)

5. Example: Using VLOOKUP" Content: Suppose we have a table of country names, and we want to retrieve the life expectancy of a particular country. Function: =VLOOKUP(A2, A2:F112, 5, FALSE) Explanation: lookup_value : A2 (Country) table_array : A2:F112 (Employee table) col_index_num : 5 (Life expectancy column) range_lookup : FALSE (Exact match) Result: VLOOKUP returns the salary corresponding to the specified employee ID.