Think of INDEX as a storage "container" used in a formula.

=INDEX(A1:A10

We have the values in the range A1:A10 "stored in the container". Now, we
use the other arguments of the INDEX function to tell it which one of those
stored values we want as the result of the formula.

Consider this simple example:

...........A
1.....Tom
2.....Sue
3.....Joe
4.....Lisa
5.....Karen

=INDEX(A1:A5,4)

In it's simplest form, that formula means return the 4th item from the
indexed ("stored") values.

The 4th value = Lisa

The arguments used to get the result you want can be very simple like above
or they can be very complex depending on the application.


--
Biff
Microsoft Excel MVP


"grateful" wrote in message
...
This one worked as well. Can you tell me why I would use "INDEX"? what
does
it do?

THANK YOU!

"T. Valko" wrote:

Enter this formula in cell S4:

=INDEX('August 31, 2008 (2)'!J:J,MATCH(C4,'August 31, 2008 (2)'!C:C,0))

--
Biff
Microsoft Excel MVP


"grateful" wrote in message
...
Hello.

I feel like I've gotten far, but not far enough...If you can help, I
would
be greatful. Thank you.

I used this formula to identify the row I was looking for in my
worksheet
titled, August 31, 2008:
=MATCH(C4,'August 31, 2008 (2)'!C:C,FALSE)

The answer is 14

Now I need to bring the value of cell J14 in august 31, 2008 over to
worksheet Nov 6, 2008 and place it in cell S4.

Can you help me with a formula to do that? It seems like it should be
easy,
but my mind keeps going in circles...

Thank you.