ExcelBanter - return the value in a cell at the intersection of a row and a colu

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - return the value in a cell at the intersection of a row and a colu (https://www.excelbanter.com/excel-discussion-misc-queries/125538-return-value-cell-intersection-row-colu.html)

Dave F

return the value in a cell at the intersection of a row and a colu

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.

Dave F

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.

All times are GMT +1. The time now is 04:57 PM.