| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Variable Column references
For a manpower planning tool, I want to be able to use a value in say cell A1
to be able to reference along from the current cell the number of columns specified in that cell, and down a known number. For example if A1=4 then I want B2 to point to (say) (C+A1)3 ie G3, & B3 to point to (D+A1)3 ie H3 etc so that I can change which column B2 point to by changing the value in A1 -- Gidders |
|
#2
|
|||
|
|||
|
Try
=OFFSET($C$3,0,$A$1+ROW(B2)-2) "Gidders" wrote: For a manpower planning tool, I want to be able to use a value in say cell A1 to be able to reference along from the current cell the number of columns specified in that cell, and down a known number. For example if A1=4 then I want B2 to point to (say) (C+A1)3 ie G3, & B3 to point to (D+A1)3 ie H3 etc so that I can change which column B2 point to by changing the value in A1 -- Gidders |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| variable worksheet references | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
