Pinterest Pixel

INDEX Function Introduction

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

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

INDEX Function Introduction | MyExcelOnline INDEX Function Introduction | MyExcelOnline

 

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.

INDEX Function Introduction | MyExcelOnline

Download excel workbookIndex_Intro.xlsx

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(

INDEX Function Introduction

 

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

Array

What is the table of source data?

See also  How to Apply Formula to Entire Column in Excel: Easiest Methods Explained

We need to select the pricing table here.

=INDEX(C16:E19,

INDEX Function Introduction

Row_num

What row number contains the data?

Since we want the laptop, it’s on row #2

=INDEX(C16:E19, 2,

INDEX Function Introduction

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)

INDEX Function Introduction

 

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,

INDEX Function Introduction

Row_num

What row number contains the data?

Since we want the laptop, it’s on row #2

=INDEX(C16:E19, 2,

INDEX Function Introduction

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)

INDEX Function Introduction

You now have your prices!

INDEX Function Introduction

How to Use the Index Formula in Excel

 

If you like this Excel tip, please share it
INDEX Function Introduction | MyExcelOnline INDEX Function Introduction | MyExcelOnline
See also  DATEDIF function: Introduction
Founder & Chief Inspirational Officer at MyExcelOnline.com

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 Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...