View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
grateful grateful is offline
external usenet poster
 
Posts: 34
Default I found Row 14 in wksh 2, can I get the value of J14 into wksh

Thank you!

"FiluDlidu" wrote:

In cell S4 of sheet Nov 6, 2008:
=indirect("'august 31, 2008'!J"&MATCH(C4,'August 31, 2008 (2)'!C:C,FALSE))

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