Return cell value based on position of another cell

[Thom7890]

Hello all, I have non-adjacent data I wish to make a line graph from (see below). The raw data is not in normal from to be visually appealing - so I attempted to turn the data into a more graphable form in another location in the worksheet. So column K lists the dates in order with a simple 'add 1 to the previous cell' formula with K1 as =A3 and K2 as K1+1. However, I want an easy way of pulling the variable data from A6 to L1, A18 to L2, A30 to L3 and so on. I can't find a function to pull this off without having to do it manually. It's been 3 years since I used Excel professionally and I apologize if this is a no brainer. Thanks

ie
A2 - Date
A3 - July 9

A5 - Sales
A6 - 123

A14 - Date (always 12 cells from previous, in this case - from A2)
A15 - July 10 (same 12 cells from previous...

A17 - Sales (12 from previous...
A18 - 234 (and so on...)

[humdingaling]

one way
put into L1 and fill down
=INDIRECT("A"&6+(12*(ROW(M1)-1)))

another
put into column M (any not used column will do)
m1 =A6
m2 = a18
m3 = a30
fill down series
then indirect(m1)

[Thom7890]

Brilliant! The equation works. I'll have to break it down to see why it works now.

Thank you hum.

[humdingaling]

A = A

6 is your starting cell
12 is the multipler
row section is the mutliple
Row (m1) = 1 filling down will increment this number
(1-1) x 12 = 0
(2-1) x 12 = 12
etc

rest is self explainatory