Thread: return the value in a cell at the intersection of a row and a colu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default return the value in a cell at the intersection of a row and a colu
Well I answered my own question. Put INDIRECT in front of the formula.

Dave
--
Brevity is the soul of wit.


"Dave F" wrote:

I know I can return a cell's address via the following:
=ADDRESS(ROW(B3),COLUMN(C3))

How would I return the cell's contents?

Dave
--
Brevity is the soul of wit.
Reply With QuoteReply With Quote