View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?