Well, apparently Indirect will not accept a dynamic named
range as an argument.

So, how can I work around this?

C1 is the dropdown that lists the months.

Here's the portion of the formula that references C1:

....SMALL(IF(INDIRECT($C$1)<""......

How can I select Jan from the dropdown and end up with
this without hard coding:

....SMALL(IF(Jan<""......

Jan is the dynamic range that refers to Sheet1!C2:Cn

Any ideas?

Thanks
-----Original Message-----
Hello everyone,

I'm having trouble using a dynamic named range through
Indirect.

I have a dropdown in cell C1 that selects the month. Each
month has a static named range. I call the month in a
formula that uses Indirect. This worked fine until I
tried
using dynamic named ranges for the months.

When using dynamic ranges INDIRECT($C$1) now evaluates to
#REF!. If I change back to static named ranges then the
formula once again works properly.

The formula for the dynamic range is correct:

=OFFSET(2004!$C$1,0,0,COUNTA(2004!$A:$A)-1,1)

Any ideas?
.