vlookup offset or index or ????

[elew69811]

On sheet 1 in cell B1 I am looking for a formula that will return what is in B1 on sheet 2 and in cell B2 on sheet 1 the formula should return what is in cell B9 on sheet 2 and in B3 on sheet 1 what is in cell B17 on sheet 2 and can be copied down so each cell down on sheet 1 looks down 8 more rows. Someone sent me a few last night and I have been unable to make them work. Thanks

SHEET 1
A B C D E F G H I J K L M N
1 Jeff Paul Harry Steve Tim Mark Dave
2 Jeff Paul Harry Steve Tim Mark Dave
3 Jeff Paul Harry Steve Tim Mark Dave
4 Jeff Paul Harry Steve Tim Mark Dave
5 Jeff Paul Harry Steve Tim Mark Dave
6 Jeff Paul Harry Steve Tim Mark Dave


SHEET 2
A B
1 Jeff $11,459
2 Paul $10,688
3 Harry $13,868
4 Steve $10,758
5 Tim $9,762
6 Mark $9,045
7 Dave $11,774
8 George $12,695
9 Jeff $11,460
10 Paul $12,440
11 Harry $10,472
12 Steve $11,455
13 Tim $12,140
14 Mark $13,454
15 Dave $13,543
16 George $11,288
17 Jeff $10,115
18 Paul $11,630
19 Harry $10,787
20 Steve $15,259
21 Tim $14,777
22 Mark $12,762
23 Dave $13,775
24 George $14,726
25 Jeff $14,379

 

[FDibbins]

Im confused with exactly what you are trying o do here, can you try explaining again?

 

[elew69811]

I have two sheets that are formatted differently and there are certain cells where I need to enter the same # so when I enter it on sheet 2 I would like it to populate on sheet 1. The data will always be in an incremental row that I would like to bring into sheet 1. Like row 1,7,14,21,28,35..... on sheet 2 and I want that in rows 1,2,3,4,5....on sheet 1. Is that any clearer? when I pasted the samples they did not stay formatted.

Thanks

 

[FDibbins]

x-posted...AND answered, here...
vlookup or index or idex or ??????