Prev: Change in cell content alert
Next: How do you count the number of * in a string?
From: Elton Law on 14 Jan 2010 07:10
Dear expert,

If A1 has a figure 39, If A2 has a figure 3, actually it is meant for row 39
and column C.
How can I type the function in B1, so that it can capture the info in C39
(column 3 and row 39)
Thanks
Elton
From: Stefi on 14 Jan 2010 07:16
=INDIRECT(ADDRESS(A1,A2,4,1))

--
Regards!
Stefi



„Elton Law” ezt írta:

> Dear expert,
>
> If A1 has a figure 39, If A2 has a figure 3, actually it is meant for row 39
> and column C.
> How can I type the function in B1, so that it can capture the info in C39
> (column 3 and row 39)
> Thanks
> Elton
From: Elton Law on 14 Jan 2010 20:06
Thanks. It works ...

"Stefi" wrote:

> =INDIRECT(ADDRESS(A1,A2,4,1))
>
> --
> Regards!
> Stefi
>
>
>
> „Elton Law” ezt írta:
>
> > Dear expert,
> >
> > If A1 has a figure 39, If A2 has a figure 3, actually it is meant for row 39
> > and column C.
> > How can I type the function in B1, so that it can capture the info in C39
> > (column 3 and row 39)
> > Thanks
> > Elton
 | 
Pages: 1
Prev: Change in cell content alert
Next: How do you count the number of * in a string?