Ok, I will have to look at it again and see if I understand it, now that I
see how it works. Thank you.

"David Biddulph" wrote:

INDIRECT is an Excel function, and you can look it up in Excel help. The
same applies to INDEX, to answer one of your other questions on this thread.
--
David Biddulph

"grateful" wrote in message
...
Wow! Thank you so much! It works perfectly, and I am able to continue
working.

I think I understand most of the formula. I am not sure what "Indirect"
means, or when to use it.

But this works and I am so happy! Thank you very much!



"Sheeloo" wrote:

Try
=INDIRECT("'August 31, 2008 (2)'!J"&MATCH(C4,'August 31, 2008
(2)'!C:C,FALSE))

It has three parts
First a string 'August 31, 2008 (2)'!J with quotes around it,
second a & to join the first part with the third part, which is your
formula returning 14.
The string within INDIRECT evaluates to 'August 31, 2008 (2)'!J14
and Indirect goes to that address and fetches the result.

"grateful" wrote:

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.