If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1?
About the following? Would that do it?
=indirect("J"&MATCH(C4,'August 31, 2008 (2)'!C:C,FALSE)) Regards, Feelu "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. |
#3
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1?
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. |
#4
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1?
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. |
#5
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1?
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. |
#6
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh
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. |
#7
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh
This one didn't work, it returned a "0". But the answer below worked. thank
you so much! "FiluDlidu" wrote: About the following? Would that do it? =indirect("J"&MATCH(C4,'August 31, 2008 (2)'!C:C,FALSE)) Regards, Feelu "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. |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh
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. |
#10
|
|||
|
|||
I found Row 14 in wksh 2, can I get the value of J14 into wksh
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. |
|
Thread Tools | |
Display Modes | |
|
|