Hard code column number in OFFSET formula

**maacmaac** · 11-02-2010, 02:49 PM

I am using following formula with chart.

Please Login or Register  to view this content.

Is there a way to hardcode the number of columns (which currently set to move 40 columns to the right of the YValues variable) as the column of the YValue name variable does not always start in the same column. For example, the data being referred to is always in column AQ (column 43).

**Bob Phillips** · 11-02-2010, 02:58 PM

Try

=OFFSET(YValues,0,COLUMN(YValues)+39)

**maacmaac** · 11-02-2010, 03:23 PM

Thanks for prompt response but not quite what I was looking for.

As an example, the YValues are in column 3. The formula you provided puts the data 42 rows to the right of column 3. Tommorrow the YValues may be in column 10, which is going to be pulling data from the incorrect column. The column I need is always column 43. I tried using following but this did not work either.

=OFFSET(YValues,0,COLUMN(43))

Thanks again.