| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
| How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Threaded Mode
