Again, under the scenario you described:

=INDIRECT(cellabove&"!MonthSales")

works just fine for me.

"cellabove" is a named formula that returns the contents of the cell above
it. The cell above it contains the text "London". The sheet named London has
a named range called MonthSales. The above formula returns the contents of
this range.

I don't see the problem.

--

Vasant


"Rob Hick" <rob.hick@nbs.nhs.uk> wrote in message
news:1115131576.455545.142360@g14g2000cwa.googlegroups.com...
> that not quite what i was after Vasant - i need to reference the name
> rather than 'A1'. So on my workbook (XL2000):
>
> =London!MonthSales
> is ok but
> =INDIRECT("London!MonthSales")
> or any permuation of getting the correct text, does not work
>
> Rob
>