Tableau is a data visualization tool that lets us analyze virtually any type of structured data and produce highly interactive and attractive graphs, dashboards ...

Excel
Lookup functions

1. INTRODUCTION TO VLOOKUP VLOOKUP functionality in Microsoft Excel. We will learn how to use this powerful tool to search for and retrieve data from a table. Understanding VLOOKUP is essential for efficient data analysis and reporting in Excel.

2. Syntax of VLOOKUP The syntax of the VLOOKUP function consists of four main elements: lookup_value, table_array, col_index_num, and range_lookup.

3. WHAT IS VLOOKUP USING MATCH? 1. VLOOKUP returns information in certain cell. 2. The MATCH function returns the relative position of item in the range. 3. both can together use for dynamic function.

Syntax = vlookup (lookup value,table array,MATCH( lokkup value,lookup array,[match type],[range lookup])

4. Introduction to Index and Match Functions in Excel The Index and Match functions in Microsoft Excel are powerful tools that allow you to perform dynamic lookups and retrieve data from a table or range. These functions can be combined to create complex formulas that can solve a wide range of data analysis challenges.

5. When to Use the Index Function The Index function is useful when you know the row and column numbers you want to reference, such as in a fixed data table. This allows you to dynamically retrieve values from a specific location within a range or table.

6. When to Use the Match Function When you need to find the row or column number based on a specific value, such as in a dynamic data set.

7. Combine Index and Match When you need to retrieve a value from a table or range based on a specific criteria, such as looking up a product price by product name.

8. Combining Index and Match for Lookups Step 1 Use the Match function to find the row or column number of the desired value. Step 2 Use the Index function to retrieve the value from the corresponding row and column. Step 3 Combine the Index and Match functions into a single powerful lookup formula.

9. HLOOKUP Horizontal Lookup can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. Syntax: = Hlookup (HLOOKUP( lookup_value , table_array , row_index_num , [ range_lookup ])

10. HLOOKUP HLOOKUP function, which returns a value from a specified row within a table, and the MATCH function, which returns the relative position within an array (a range of cells spanning across a single row or column). These two functions, when nested together, will serve as a relatively simple solution to a complex question

11. Thank You Thank you for joining us today for this presentation on Index and Match functions in Excel.