View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How to determine the value within specific cell position?

=B5

Eric wrote:
For example, if cell B5 contains text "Apple", which cell's position is
row()=5 and column()=2, so I would like to return the value into cell A1
based on the row and column number.