View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default is there a function for getting the content of a cell?

On Sat, 12 Nov 2005 07:28:16 -0600, tzvarza`
wrote:


I have 2 variables which determine the row and the column of a cell. I
need to find out the number in that cell.

For example, if I have i=4 and j=2 then I need the number in B4. But I
can't write "=B4" because i and j are variables therefore I need
something like this "=cell_content(4;2)".



=INDIRECT(ADDRESS(row_num,col_num))


--ron