View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Return value from cell info

=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