LOOKUP Formula

I'm having some trouble with a lookup formula.

In row 6 J through Z I have numbers from 1 through 17

In row 8 J through Z I have random numbers for example J8 = 3

In B83, I enter a number from 1 through 17

In cell d8 what I need is the LOOKUP that looks at the number in cell
B83 finds the matching number in row 6 and then returns the number
associated with the reference from row 8

As an example then if B83 = 1 and J6 = 1 then return the number in J8
which in the above is 3

Thanks for all help

One way

=HLOOKUP(B83,J6:Z8,3,0)

--

Regards,

Peo Sjoblom

"SFrick" wrote in message
...
I'm having some trouble with a lookup formula.

In row 6 J through Z I have numbers from 1 through 17

In row 8 J through Z I have random numbers for example J8 = 3

In B83, I enter a number from 1 through 17

In cell d8 what I need is the LOOKUP that looks at the number in cell
B83 finds the matching number in row 6 and then returns the number
associated with the reference from row 8

As an example then if B83 = 1 and J6 = 1 then return the number in J8
which in the above is 3

Thanks for all help

Peo,

Thanks for the quick reply. The formula would work but I have a
problem with it that perhaps I should have explained more.

B83 = # Number from 1 through 17

J6:Z6 Numbers from 1 through 17 i.e. J6=1, K6=2, L6=3 etc.

Col's J through Z Rows 8 through 81 have random numbers

Column D, rows 8 through 81 is where I need the Lookup formulas. For
example in D8 if the number in B83 is say 1 then the Lookup formula
would find the number 1 in row 6 (J6 in this example) and then return
the number 1 in D8.

Does this explain it better?














On Tue, 16 Sep 2003 18:51:40 -0400, "Peo Sjoblom"
wrote:

One way

=HLOOKUP(B83,J6:Z8,3,0)

I'm not sure I understand what you're after but I took a shot at it anyway.

=OFFSET(J8,0,$B$83-1)

HTH

-Dave

"SFrick" wrote in message
...
Peo,

Thanks for the quick reply. The formula would work but I have a
problem with it that perhaps I should have explained more.

B83 = # Number from 1 through 17

J6:Z6 Numbers from 1 through 17 i.e. J6=1, K6=2, L6=3 etc.

Col's J through Z Rows 8 through 81 have random numbers

Column D, rows 8 through 81 is where I need the Lookup formulas. For
example in D8 if the number in B83 is say 1 then the Lookup formula
would find the number 1 in row 6 (J6 in this example) and then return
the number 1 in D8.

Does this explain it better?














On Tue, 16 Sep 2003 18:51:40 -0400, "Peo Sjoblom"
wrote:

One way

=HLOOKUP(B83,J6:Z8,3,0)