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.





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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Sumproduct & Weighted Averages A quick way to calculate the weighted average of two lists of data is to use the Sumproduct formula.  A weighted average can be used to determine the average salary of employees, the average grade of an exam or the average selling price of a company´s stock list, as can been seen...
Advanced SUMPRODUCT Function: Conditional Date If you want to find out the total sales for a particular month, then the SUMPRODUCT function is your answer.  You can create a criteria for a specific date range, a particular month or a year.In the example below I show you how to use the SUMPRODUCT function to sum up the tot...
VLOOKUP with Multiple Criteria in Excel ‘VLOOKUP’ is now so common that everyone who has ever been working with Excel has heard of it. Not necessarily because they know how to use it, but because some savvy Excel-user always talks about it at the office.Advanced users have seen the use of adding more than one...
GETPIVOTDATA Function What does it do?A formula that extracts data stored in a Pivot TableFormula breakdown:=GETPIVOTDATA(data_field, pivot_table, , ,...)What it means:=GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...) T...