| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| 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
