Index function, the difference between value and reference.

[arishy]

=INDEX(A1:A5,2)

...returns a reference to cell A2.


And,


=INDEX({95,96,97,98,99},5)

...returns the value of 99.


So, I put 95...99 in A1..A5


And run it, I got 99 in BOTH cases.


If reference means "address" of a variable I should get A5 not 99


Can someone "fix" my logic !!!!


And if they are different how can I use one and not the other in an example.

 

[Hui]

Arishy


Have a look at the article at ExcelHero.com

http://www.excelhero.com/blog/2011/03/the-imposing-index.html