ExcelBanter - Variable Column references

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Variable Column references (https://www.excelbanter.com/excel-worksheet-functions/35573-variable-column-references.html)

Gidders

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

Duke Carey

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

All times are GMT +1. The time now is 07:20 AM.