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?