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
|