=IF($C$16="BPOH",BPOH,OFFSET(INDIRECT($C$16),ROW(A 1)-1,COLUMN(A1)-1))

The above wasn't consistent with what was suggested earlier

=IF($C$16="BPOH",BPOH, ...
should read as:

=IF($C$16="","", ...

Try this working sample file which illustrates the earlier suggestion:
http://www.savefile.com/files/387065
Display specified name range.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Lori wrote:
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