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.

Exactly!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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.

That is correct


Peo Sjoblom


Dave F wrote:
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

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.

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.

Yes they are! Reliving my high school Geometry class...

"Dave F" wrote:

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.

a squared plus b squared equals c squared

--
Brevity is the soul of wit.


"Sean Timmons" wrote:

Yes they are! Reliving my high school Geometry class...

"Dave F" wrote:

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.

x=(-b+/-sqrb^2+4ac)/2a
I think that's right, anyway. :-)

"Dave F" wrote:

a squared plus b squared equals c squared

--
Brevity is the soul of wit.


"Sean Timmons" wrote:

Yes they are! Reliving my high school Geometry class...

"Dave F" wrote:

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.

Yes but my point was the coordinate way is just another way of saying it
without using the intersection terminology.
I was NOT correcting you but someone should have corrected my "French"!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
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.

Mon francais n'est pas le mien.

Dave
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

Yes but my point was the coordinate way is just another way of saying it
without using the intersection terminology.
I was NOT correcting you but someone should have corrected my "French"!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
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.

That is correct!

Biff

"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.

Match looks for the value (G26 and H26 in this case) and returns the row
number of your G26 value in the first example and column number of the H26
value in the second example.

"Dave F" wrote:

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.