Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
can someone help me ?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
"joel" wrote in message
... can someone help me ? Please ask your question in the body of the post, not the subject line! Is this what you want? =INDIRECT("Sheet1!J"&Sheet2!A30-1) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
Joel, Next time, put your question within the body of the message, not the
subject. Next, you don't reference a cell in your "formula" in the first part, ie "J". Tell us what is in the cells you are reference so we can help you because the "&" is probably not necessary. Not sure why you have quotes. Les "joel" wrote: can someone help me ? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i convert this to a formula +"sheet1!J"&(sheet2!A30)-1
Thank you very much it is very helpfull to use such a formula.
"Stephen" wrote: "joel" wrote in message ... can someone help me ? Please ask your question in the body of the post, not the subject line! Is this what you want? =INDIRECT("Sheet1!J"&Sheet2!A30-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a text form of "=Sheet2!A1" into a reference formula | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
How do I color code the "SHEET1" Tab in Excel? | Excel Worksheet Functions | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions |