The calc mode is set to automatic.
formula: (cell C16 is where BPOH choice is entered)
=IF($C$16="BPOH",BPOH,OFFSET(INDIRECT($C$16),ROW(A 1)-1,COLUMN(A1)-1))

--
Lori


"Max" wrote:

The data that prints out is 55% in all cells...

Is the calc mode accidentally set to Manual?
Check Tools Options Calculation tab

Pl post the actual formula you are using over there
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lori" wrote in message
...
Tried your answer and got a partial response. Here is the data that
should
appear:

55.0% 55.0% 55.0%
30.0% N/A 30.0%
8.0% N/A N/A
N/A
N/A

The data that prints out is 55% in all cells. What could I be doing wrong?

--
Lori