# Excel INDEX MATCH Made Simple - Lookup like a Pro In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range.

In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range. Next, we look at how to use the match function. The match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. We then bring both index and match together to find specific values within an array. We start with a simple example and then we finish with two more advanced examples. We also look at how to set up a simple drop down list to start building an interactive dashboard.

⌚ Timestamps 0:00 Introduction 1:16 Index function 3:31 Match function 5:36 Index & match simple example 8:50 Index & match advanced example 1 11:54 Drop down lists with index match 13:01 Index & match advanced example 2 15:02 Wrap up

## Data Validation in Excel

What is Data Validation in Excel. Data validation is a feature in Excel used to control what a user can enter into a cell. Learn more about it with Examples.

Advanced Excel Online Training & Certification Courses by CETPA with Real time projects. Enroll now to get student offer of 50% on Online Course. Call us: 9212172602.

## Microsoft Excel Tutorial - Objects In Ms Excel- Excel Worksheet Objects

In this MS Excel tutorials, video we are going to see the differnce between tables and cell ranges in MS Excel. Also we are going to see that how can we create a Table from data given to us and what all changes we can apply to our tables.

## Microsoft Excel Tutorial - Slicers on Charts in MS Excel.

In this MS Excel tutorials, video we are going to apply the slicers in charts in MS Excel. However, there is no direct method of doing so, that is why we are going to use a simple trick over here. Also we are going to see that how can we connect same slicer with multiple charts in MS Excel. ​

## Excel VBA Tutorial for Beginners 19 - VBA Insert Cells in MS Excel

In this MS Excel VBA video, we are going to see the usage of the Insert Cells feature of MS Excel. Using this feature we can insert cells at some specified locations easily. In this video we will see the Overview of formulas in Excel.