# INDEX Function Introduction

What does it do? It returns a cell´s value from within a table/range Formula breakdown: =INDEX(array,... read more

## Overview

What does it do?

It returns a cell´s value from within a table/range

Formula breakdown:

=INDEX(array, row_num, [column_num])

What it means:

=INDEX(from this table/range, return me this row number, [and return me this column number])

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.

We want to get the price of a laptop in 2014 and 2015 based on price table.

STEP 1: We need to enter the INDEX function in a blank cell:
`=INDEX(`

STEP 2: The INDEX arguments for the 2014 laptop price:

## Array

What is the table of source data?

We need to select the pricing table here.
`=INDEX(C16:E19,`

## Row_num

What row number contains the data?

Since we want the laptop, it’s on row #2
`=INDEX(C16:E19, 2,`

## Column_num

What column number contains the data?

Since we want the price for the year 2014, it’s on column #2
`=INDEX(C16:E19, 2, 2)`

STEP 3: The INDEX arguments for the 2015 laptop price:

## Array

What is the table of source data?

We need to select the pricing table here.
`=INDEX(C16:E19,`

## Row_num

What row number contains the data?

Since we want the laptop, it’s on row #2
`=INDEX(C16:E19, 2,`

## Column_num

What column number contains the data?

Since we want the price for the year 2015, it’s on column #3
`=INDEX(C16:E19, 2, 3)`

##### John Michaloudis
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.