UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

INDEX Function

S
Sivasankarit
22/09/2016 0 0

Index Function has two forms:

1. Array form - returns a value

2. Reference form - returns a cell reference

 

Array Form:

Syntax: INDEX(ARRAY, row_num, col_num)

Example: INDEX({10, 20, 30; 40, 50, 60}, 1, 2)

or INDEX((a1:c1,a2:c2), 1, 2)

The result for the below example is 20. Since we have got row 1 and column 2 we get 20

A   B   C

10 20 30

40 50 60

 

The 20 in column 2 is the answer

 

Reference form:

Syntax: INDEX(reference,row no, col no, area num)

example: INDEX((C4:E5,K5:M7),3,1,2)

              C             D              E

 

5 4 3
3 2 1

 

              K              L             M

 

2 3 4
6 2 5
3 6 7

 

answer for above one is 3

In the above equation we have choosen 2 array, K5 to M7 in which the row no is 3 and col no is 1

 

Please let me know for any doubts

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

5 Tips For Improving Your Documentation Immediately.
Tip 1) Quit it with the Passive Voice The passive voice is a plague on effective documentation. It reduces its clarity, its consistency, and the efficiency and tightness of the writing. The passive voice...

How to generate datasets?
Anyone can easily generate dataset numeric datasets using RANDBETWEEN function. This function generates random numbers between specified values. After using this function you can copy the range to which...

Akhilesh Dadhich

0 0
0

SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

What is a SQL join?
A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

Idioms and meanings - Lesson 3 of 11
Choose the best option that is closest to the meaning of the idiom Idioms Beginning with E Idioms Beginning with F "Easy does it" means ___. a. let's do it laterb. let's do it carefullyc....
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more