Hi,

I have two HLOOKUP formulae and both are returning an NA value:

a) =HLOOKUP(E$2,'FY09 Monthly'!D2:BL147,$A5,0)

and

b) HLOOKUP(E$2,TestNameRange,$A5,0)

The first one (a) works but when I copy it to the next cell, I get an
NA error:

=HLOOKUP(E$2,'FY09 Monthly'!D3:BL147,$A5,0)

In the second one (b), I have given a range a name and that doesn't
work either. Does any one have any ideas?

Thanks,

Nadia