View Single Post
  #1   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 1?

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.