LOOKUP or Offeset

I did an earlier post but I guess I was not clear enough in what I
need in a formula.

In cols J through Z rows 6 through 81 is data.

Row 6, J through Z are the numbers 1 through 17, i.e. J6=1, K6=2
through Z6=17

The remaining rows, strating at row 8 have random numbers

In Cell B83 is a formula that returns a number between 1 and 17

Col D, rows 8 through 81 is my target area.

What I need is a formula that based on the number in B83 (1 through
17) will copy the data in the matching column (for example if B83 were
2, then the data set would be all data in col K) into column D.

As example;

B83 = 2
K6=2 Therefore all Col K is the data set needed.

D8 through D81 (were the formula is) returns the values from Col K

D8 Formula based on B83 = 2 returns number from col K 8
D9 Formula based on B83 = 2 returns number from col K9
D10 Formula based on B83 = 2 returns number from col K10
and so on down to D81

So whatever the value is in B83, Col D will find the matching col from
Col's J through Z, row 6 and return the corresponding value.

Hope this is clearer then my earlier post

Put this in D8 and fill down to D81
=HLOOKUP($B$83,$J$6:$Z$81,ROW()-5,FALSE)

Godd luck.......Will

-----Original Message-----
I did an earlier post but I guess I was not clear enough
in what I
need in a formula.

In cols J through Z rows 6 through 81 is data.

Row 6, J through Z are the numbers 1 through 17, i.e.
J6=1, K6=2
through Z6=17

The remaining rows, strating at row 8 have random numbers

In Cell B83 is a formula that returns a number between 1
and 17

Col D, rows 8 through 81 is my target area.

What I need is a formula that based on the number in B83
(1 through
17) will copy the data in the matching column (for
example if B83 were
2, then the data set would be all data in col K) into
column D.

As example;

B83 = 2
K6=2 Therefore all Col K is the data set needed.

D8 through D81 (were the formula is) returns the values
from Col K

D8 Formula based on B83 = 2 returns number from col K 8
D9 Formula based on B83 = 2 returns number from col K9
D10 Formula based on B83 = 2 returns number from col K10
and so on down to D81

So whatever the value is in B83, Col D will find the
matching col from
Col's J through Z, row 6 and return the corresponding
value.

Hope this is clearer then my earlier post
.