Hi Don,

You need to combine INDIRECT and ADDRESS like this;

=INDIRECT(ADDRESS(row, column,1, TRUE, sheet))

where;
row = cell containing row no
column = cell containing column no
sheet = cell containinig sheet name

of the data you are trying to get.

And you can get fancy, like
=SUM(INDIRECT(ADDRESS($A$1,$B$1,,,)):INDIRECT(ADDR ESS($A$2,$B$2,,,)))
to sum a range defined by row/column no entries in four cells.


There is a sample here
http://www.edferrero.com/ExcelCharts...2/Default.aspx
look for the Reporting sample.

Ed Ferrero
www.edferrero.com