LOOKUP or Offeset

S

SFrick

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
 

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