Thread: How can I use a cell value to reference a row?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default 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.
Reply With QuoteReply With Quote