HI there,

I don't know if you are still around or still able to help me. It's a year
later, and I find myslef needing to add on to this formula....and as much as
I try to fool with it...to no avail.

I have this formula (It works perfectly): =IF(ISERROR((INDIRECT("'August 31,
2008'!H"&MATCH(C7,'August 31, 2008'!C:C,FALSE)) + H7)/(INDIRECT("'August 31,
2008'!J"&MATCH(C7,'August 31,
2008'!C:C,FALSE))+J7)),IF(L70.01,L7,""),((INDIREC T("'August 31,
2008'!H"&MATCH(C7,'August 31, 2008'!C:C,FALSE)) + H7)/(INDIRECT("'August 31,
2008'!J"&MATCH(C7,'August 31, 2008'!C:C,FALSE))+J7)))

What I need to do is now incorporate information from another worksheet:
August 28, 2009

In the N column is where I incorporated the formula above in my current
sheet. It compared info from Sheet August 31, 2008 and added any relevant
info into my current sheet. Now I need it to analyze August 31, 2008 and
August 27, 2009 and work out the same rate. If the C cell match, to add the
sums of cells H in all three sheets, and the sums of cells J in all three
cells, and divide the sums H/J in Cell 3.

Does that make any sense?

Thank you for all the help.



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