| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
