Manuals/calci/INDEX

Syntax

---

Examples-1

---

'''''''  ''''

---

Description

---

 This function gives the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in.

---

INDEX

---

 

Reference form

INDEX(ref,RN,CN,AN)

where ref is a reference to one or more cell ranges,

RN   is the number of the row in reference ,CN    is the number of the column in reference from which to return a reference,AN  selects a range in reference from which to return the intersection of RN and CN.

---

	Column1	Column2	Column3	Column4
Row1	Grapes	.49	50
Row2	Guava	0.50	30
Row3	watermelon	0.55	25
Row4	Pineapple	0.45	15
Row5	25
Row6

File:Calci1.gif

---

  Let's see an example in Column1Row1:Column3Row4

I.e

B                      C              D

Grapes             .      49                  50

Guava                   0.50                  30

Water Melon        0.55                   25

Pine Apple            0.45                  15

I.e. =INDEX(Column1Row1:Column3Row4,3,3) is 25

---