The INDEX function in Excel returns a cell´s values from within a table/array.

It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers).

So if you want to return values from a Price List or large data set, then your INDEX function is your savior.

DOWNLOAD WORKBOOK

Index_Intro

HELPFUL RESOURCE:

MOTH-excel_expert470x63

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Autosum an Array of Data in Excel When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill in the Totals with the Autosum button.STEP 1: Highlight your data including the "Totals" row and column;STEP 2: Click the Autosum button (under the Home or...
Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function....
Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done:1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...
Calculate Elapsed Time in Excel When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT functionSometimes data gets dumped into Excel with the following date & time format:24/01/2015  19:48:00.Using the TEXT function and enter...