reference with variable row number ?
 

I'm trying to lookup a vector ( Bx:Sx )
in which x is a number stored in another cell, say Cell A1..

I was trying something like: LOOKUP ( 1, B(A1):S(A1), B1:S1)
which, of course does not work...^___^

So can I ask how can I reference a cell with the row number being a variable?

reference with variable row number ?
 

See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff

"Arc_K" wrote in message
...
I'm trying to lookup a vector ( Bx:Sx )
in which x is a number stored in another cell, say Cell A1..

I was trying something like: LOOKUP ( 1, B(A1):S(A1), B1:S1)
which, of course does not work...^___^

So can I ask how can I reference a cell with the row number being a
variable?

reference with variable row number ?
 

Biff,

For the benefit of all and the excel archives, why not include the core text
descripts of your suggestion? Your image link can be a complement to that.
Perhaps, like other silent readers of the newsgroups around the world
travelling in the same boat, I'm unfortunately not able to view the link
from where I'm accessing the newsgroups. If you were to include the core
text descripts, think that'll definitely be visible.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff

reference with variable row number ?
 

Well, there wasn't enough detail in the post so I basically took a WAG as to
what they wanted and it goes like this:

.......A.....B.....C.....D
1...X1...X2...X3...X4
2....5......8......7.....6
3....1......4......7.....2
4....0......6......1.....3
5....9......2......8.....4
6....8......4......1.....7

Return column header based on the (relative) user selected row that contains
the lookup value.

A10 = lookup value = 1
A11 = row number = 5

=INDEX(A1:D1,MATCH(A10,INDEX(A2:D6,A11,),0))

Returns: X3

Biff

"Max" wrote in message
...
Biff,

For the benefit of all and the excel archives, why not include the core
text descripts of your suggestion? Your image link can be a complement to
that. Perhaps, like other silent readers of the newsgroups around the
world travelling in the same boat, I'm unfortunately not able to view the
link from where I'm accessing the newsgroups. If you were to include the
core text descripts, think that'll definitely be visible.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff

reference with variable row number ?
 

Thanks, Biff !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
Well, there wasn't enough detail in the post so I basically took a WAG as
to what they wanted and it goes like this:

......A.....B.....C.....D
1...X1...X2...X3...X4
2....5......8......7.....6
3....1......4......7.....2
4....0......6......1.....3
5....9......2......8.....4
6....8......4......1.....7

Return column header based on the (relative) user selected row that
contains the lookup value.

A10 = lookup value = 1
A11 = row number = 5

=INDEX(A1:D1,MATCH(A10,INDEX(A2:D6,A11,),0))

Returns: X3

Biff

reference with variable row number ?
 

You're welcome, Max!

Biff

"Max" wrote in message
...
Thanks, Biff !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
Well, there wasn't enough detail in the post so I basically took a WAG as
to what they wanted and it goes like this:

......A.....B.....C.....D
1...X1...X2...X3...X4
2....5......8......7.....6
3....1......4......7.....2
4....0......6......1.....3
5....9......2......8.....4
6....8......4......1.....7

Return column header based on the (relative) user selected row that
contains the lookup value.

A10 = lookup value = 1
A11 = row number = 5

=INDEX(A1:D1,MATCH(A10,INDEX(A2:D6,A11,),0))

Returns: X3

Biff

reference with variable row number ?
 

Oh Now I can get my assighment done~~~

Thanks a lot !


"Biff" wrote:

See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff

"Arc_K" wrote in message
...
I'm trying to lookup a vector ( Bx:Sx )
in which x is a number stored in another cell, say Cell A1..

I was trying something like: LOOKUP ( 1, B(A1):S(A1), B1:S1)
which, of course does not work...^___^

So can I ask how can I reference a cell with the row number being a
variable?

reference with variable row number ?
 

You're welcome. Thanks for the feedback!

Biff

"Arc_K" wrote in message
...
Oh Now I can get my assighment done~~~

Thanks a lot !


"Biff" wrote:

See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff

"Arc_K" wrote in message
...
I'm trying to lookup a vector ( Bx:Sx )
in which x is a number stored in another cell, say Cell A1..

I was trying something like: LOOKUP ( 1, B(A1):S(A1), B1:S1)
which, of course does not work...^___^

So can I ask how can I reference a cell with the row number being a
variable?