how do i put increments in the row or column numbers?

B

brigits

with sheet1, i have a column, no. of days, which calls a cell in sheet2.

sheet1:
staff no. of days
ann A2 - calls sheet1!A8
jess A3 - calls sheet1!A19
staff c A4 - how do i automatically call sheet1!30 (A3 calls
sheet1!A19 plus 11 cells - 11 rows down?)
etc A5 calls so on...sheet1!A41, A52, A63...

sheet2:
A B C D E
1 Staff Time S M T
2 ann 8:00-8:30 AM comm wtc comm
3 8:30-9:00 AM comm wtc comm
4 Total: 9:00-9:30 AM comm wtc comm
5 6 4/8 9:30-10:00 AM comm wtc comm
6 10:00-10:30 AM comm comm comm
7 Days: 10:30-11:00 AM comm comm comm
8 6.5 11:00-11:30 AM comm comm comm
9 11:30-12:00 PM comm comm comm
10
11 A B C D E
12 Staff Time S M T
13 jess 8:00-8:30 AM comm wtc
14 8:30-9:00 AM comm wtc
15 Total: 9:00-9:30 AM comm wtc
16 6 4/8 9:30-10:00 AM comm wtc
17 10:00-10:30 AM comm comm
18 Days: 10:30-11:00 AM comm comm
19 6.5 11:00-11:30 AM comm comm comm
20 11:30-12:00 PM comm comm comm

is there a formula like R[11]C[1] which adds 11 to the current row number or
something? please help, thanks.
 
B

Bernard Liengme

Either of these
=INDEX(Sheet1!A:A,(ROW()-1)*11-3)
=INDIRECT("Sheet1!A"&(ROW()-1)*11-3)
placed in A2 and copied down the column
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top