Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell address in the Offset formla
I am using a formula =OFFSET(B2,0,6). The 6 refers to the 6th column to the
right but I want to use a reference to a cell range in there instead, in this case H3. How can I do this? -- thanks, Neil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell address in the Offset formla
Your question isn't quite clear. I am assuming you have a cell reference
listed in a cell, and you want to offset from the cell reference? i.e.: in cell B2 you have H3. in that case, your formula would be: =OFFSET(INDIRECT(B2),0,6) If that isn't what you want, please provide a little more detail, current data, current result data, expected result data. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Highlystrung" wrote: I am using a formula =OFFSET(B2,0,6). The 6 refers to the 6th column to the right but I want to use a reference to a cell range in there instead, in this case H3. How can I do this? -- thanks, Neil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell address in the Offset formla
John, clearly misled you. I want to use a cell reference instead of a column
offset so instead of putting 6 in for the number of columns to the right I want to put the cell address e.g. 6 right from B2 = H2, regards, Neil -- thanks, Neil "John C" wrote: Your question isn't quite clear. I am assuming you have a cell reference listed in a cell, and you want to offset from the cell reference? i.e.: in cell B2 you have H3. in that case, your formula would be: =OFFSET(INDIRECT(B2),0,6) If that isn't what you want, please provide a little more detail, current data, current result data, expected result data. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Highlystrung" wrote: I am using a formula =OFFSET(B2,0,6). The 6 refers to the 6th column to the right but I want to use a reference to a cell range in there instead, in this case H3. How can I do this? -- thanks, Neil |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell address in the Offset formla
Ok, I am still not understanding what you are trying to do. If you just want
a cell reference that is 6 columns to the right of a cell, i.e: if you want B2 to equal to the value of H2, why not just =H2? If I put the formula =ADDRESS(ROW(),COLUMN()+6,4) in cell B2, it will return H2, is that what you are seeking? If not, try to go into more detail of what is in B2, what is in H2, and where does the 6 come from, and will you need to be changing rows as well. -- ** John C ** "Highlystrung" wrote: John, clearly misled you. I want to use a cell reference instead of a column offset so instead of putting 6 in for the number of columns to the right I want to put the cell address e.g. 6 right from B2 = H2, regards, Neil -- thanks, Neil "John C" wrote: Your question isn't quite clear. I am assuming you have a cell reference listed in a cell, and you want to offset from the cell reference? i.e.: in cell B2 you have H3. in that case, your formula would be: =OFFSET(INDIRECT(B2),0,6) If that isn't what you want, please provide a little more detail, current data, current result data, expected result data. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Highlystrung" wrote: I am using a formula =OFFSET(B2,0,6). The 6 refers to the 6th column to the right but I want to use a reference to a cell range in there instead, in this case H3. How can I do this? -- thanks, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pass Cell Address to OFFSET | Excel Worksheet Functions | |||
Referencing the same cell address while copying a formula | Excel Worksheet Functions | |||
SUM, OFFSET and CELL("address") | Excel Worksheet Functions | |||
Offset with Cell("address") | Excel Worksheet Functions | |||
Passing Cell Address to Offset | Excel Worksheet Functions |