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.