| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Variable range reference
How do I use the value of a cell as a reference to a range?
I have a cell value that is assigned by a series of IF statements. I would like to use the value of this cell within a INDEX and MATCH function to define the range. |
|
#2
|
|||
|
|||
|
Variable range reference
=indirect()
??? =index(indirect(a1), ....) if A1 contained something that looked like an address. Kyle Szukaitis wrote: How do I use the value of a cell as a reference to a range? I have a cell value that is assigned by a series of IF statements. I would like to use the value of this cell within a INDEX and MATCH function to define the range. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locating variable range to copy | New Users to Excel | |||
| MIN Function w/ variable address reference | Excel Worksheet Functions | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
| variable range automation | Charts and Charting in Excel | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
Linear Mode
