| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use a cell value to reference a row?
a5 is an integer variable from 15 to 925 in increments of 1. When a5 is 20
cell a10 (or any cell I chose) should read the contents of j20. When a5 is 825 cell a10 should read the contents of j825. The integer value in a5 defines the row of column j returned in cell a10. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a cell value to reference a row?
Take a look at the indirect function in Excel It will allow you to set your
reference dynamically. Something like this =INDIRECT("Sheet1!J" & A5) -- HTH... Jim Thomlinson "excelchallenged" wrote: a5 is an integer variable from 15 to 925 in increments of 1. When a5 is 20 cell a10 (or any cell I chose) should read the contents of j20. When a5 is 825 cell a10 should read the contents of j825. The integer value in a5 defines the row of column j returned in cell a10. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a cell value to reference a row?
Hello Excelchallenged, In cell A10 place the formula... =INDIRECT("J" & A5) Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=509173 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a cell value to reference a row?
excelchallenged Wrote: a5 is an integer variable from 15 to 925 in increments of 1. When a5 i 20 cell a10 (or any cell I chose) should read the contents of j20. When a is 825 cell a10 should read the contents of j825. The integer value in a5 defines the row of column j returned in cell a10. why not temp=[A5] cells(10,"A").value=cells(temp,"j").value A V Veerka -- avveerka ----------------------------------------------------------------------- avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033 View this thread: http://www.excelforum.com/showthread.php?threadid=50917 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use a cell value to reference a row?
While indirect is a volitile function meaning that it will recalcualte every
thime the sheet calculates it will (in all likelyhood) still be more efficient than using the on change event handler that you are proposing. Built in functions are almost always more efficient than code. If you want to try it though be my guest. It will work... -- HTH... Jim Thomlinson "avveerkar" wrote: excelchallenged Wrote: a5 is an integer variable from 15 to 925 in increments of 1. When a5 is 20 cell a10 (or any cell I chose) should read the contents of j20. When a5 is 825 cell a10 should read the contents of j825. The integer value in a5 defines the row of column j returned in cell a10. why not temp=[A5] cells(10,"A").value=cells(temp,"j").value A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=509173 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
