Look for value that is six columns apart
 

I have a spreadsheet that has a diffent column title every six columns. The
data for the spreadsheet is coming from a query. How can I reference the
columns that are at a constant of six columns apart? For example:

Column
A B C D E F
Part 1 XX XX XX XX Part 2

I need for the formula to reference Part 2, and subsequently Part 3 located
in column L, row 1.

Thanks, Pablo

Look for value that is six columns apart
 

Have a look in the help index for OFFSET

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pablo" wrote in message
...
I have a spreadsheet that has a diffent column title every six columns.
The
data for the spreadsheet is coming from a query. How can I reference the
columns that are at a constant of six columns apart? For example:

Column
A B C D E F
Part 1 XX XX XX XX Part 2

I need for the formula to reference Part 2, and subsequently Part 3
located
in column L, row 1.

Thanks, Pablo

Look for value that is six columns apart
 

With Part 2 in Column F,
Part 3 in Column L,
Part 4 in Column R,
.... etc.

If copying *down*, use:
=INDEX($1:$1,6*ROWS($1:1))

If copying *across*, use:
=INDEX($1:$1,6*COLUMNS($A:A))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pablo" wrote in message
...
I have a spreadsheet that has a diffent column title every six columns.
The
data for the spreadsheet is coming from a query. How can I reference the
columns that are at a constant of six columns apart? For example:

Column
A B C D E F
Part 1 XX XX XX XX Part 2

I need for the formula to reference Part 2, and subsequently Part 3
located
in column L, row 1.

Thanks, Pablo