View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Return value from cell info

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