is there a function for getting the content of a cell?

T

tzvarza`

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)".
 
R

Ron Rosenfeld

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)".
Click to expand...


=INDIRECT(ADDRESS(row_num,col_num))


--ron
 
T

tzvarza`

The function ADDRESS is what I tried to use, but didn't manage to ge
the actual number.

Now I tested INDIRECT(ADDRESS(row_num,col_num)) and it works just fin
:D

10x for your hel
 
R

Ron Rosenfeld

The function ADDRESS is what I tried to use, but didn't manage to get
the actual number.

Now I tested INDIRECT(ADDRESS(row_num,col_num)) and it works just fine
:D

10x for your help
Click to expand...


You're welcome. Thanks for the feedback.

--ron
 
Top