reference with variable row number ?

[Guest]

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?

 

[Biff]

See if this screencap helps:

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

Biff

 

[Max]

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.

 

[Biff]

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(A11,MATCH(A10,INDEX(A26,A11,),0))

Returns: X3

Biff

 

[Max]

Thanks, Biff !

 

[Biff]

You're welcome, Max!

Biff

Thanks, Biff !

 

[Guest]

Oh Now I can get my assighment done~~~

Thanks a lot !

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Oh Now I can get my assighment done~~~

Thanks a lot !