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