cell contents from a reference
 

how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications

cell contents from a reference
 

=INDIRECT(ADDRESS(ROW(A10),COLUMN(A5)+5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"NimbleThunder" wrote in message
...
how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications

cell contents from a reference
 

Hi,

Try:

=INDIRECT(ADDRESS(ROW(A15),COLUMN(F1)))

HTH
Jean-Guy

"NimbleThunder" wrote:

how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications

cell contents from a reference
 

Row(A10), Column(A10) - same thing, isn't it? Do you want the value of A10,
do you want the value of row10+5 and Column A+5, i.e. Row 15 and Column F, or
then F15, or do you want to add 5 to the value of A10
--
Hth

Kassie Kasselman


"NimbleThunder" wrote:

how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications

cell contents from a reference
 

Thank you Chip.

Exactly what I was looking for also.

"Chip Pearson" wrote:

=INDIRECT(ADDRESS(ROW(A10),COLUMN(A5)+5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"NimbleThunder" wrote in message
...
how do I get the value stored in a cell from a reference to the cell.

Example: I want to get the value stored in:
Address(ROW(A10)+5,COLUMN(A10)+5)

what function do I use to get the value?


--
Thanks for the help,

Denis Nothern
Savvis Communications