Well, isn't a coordinate on a cartesian graph the intersection of a vertical
and horizontal axis?
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

Yes that is correct.

Normally I do not think in terms of intersections. I think of any array as
having elements with 'names' like this

a(1,1) a(2,1) a(3,1) ......
a(2,1) a(2,2) a(2,3) ......
a(3,1) a(3,2) a(3,2) ......

So I think of the I and J in INDEX(range, I, J ) as the Cartesian
coordinates of the element.
As they say "Que une a son qout"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
I just created this formula, and it works correctly, however I'm trying to
understand WHY it works.

As I understand it, INDEX can be used to find the value of an intersection
of a row and column in an array? =MATCH(G26,B3:B22) = 8 and
=MATCH(H26,C2:N2) = 9

So the INDEX function returns the value at the intersection of the eighth
row and ninth column in the above array.

Is this correct?

Dave


--
Brevity is the soul of wit.