Skipping Cells When Auto Filling

[brockco]

I would like to autofill every 5 cells and also have a VLOOKUP function auto fill every 5 cells. The source table of data is in a list that has no spaces.

For Example,

Sheet 1
-----A-------B-------C------D------E
1---Bob------5
2---Bill-------6
3---Steve---12
4
5

Sheet 2
-------A-------B--------C--------D
1-----Bob
2------5
3
4
5
6-----Bill
7------6
8
9
10
11--Steve
12----12

In Sheet 2, Cells A2, A7 and A12 contain VLOOKUP functions.

Thank You in advance for your help!

[mrice]

Try this..

Add a repeating sequence of 5 numbers down column B e.g. 1,2,3,4,5,1,2,3,4,5,1,2,3,4,5....

Turn autofilters on to just show the rows 2,7,12 etc (all will have a 2 in column B)

Add the vlookup formula to A2.

Drag down.

Remove the autofilter.

[Teethless mama]

Try this

Sheet2

A1: =IFERROR(INDEX(Sheet1!A:B,INT((ROWS(A$1:A1)-1)/5+1),MOD(ROWS(A$1:A1)-1,5)+1),"")

Copy down as far as needed

[brockco]

Mama, how would I do that if my table in sheet 1 had 7 columns instead of 2?