In response to Harlan - the named formula 'WorksheetName' returns the
name of the sheet on which the named formula is used. In this instance
it returns the name of the 'Summary' sheet - becuase that is actually
where the data element I want to look up is located (it's a month, e.g
April 05).

And the strange mathematics exists because the second 2 is actually
another named formula in reality - it was just easier to put 2 rather
than define another in the post.

Vasant - have you defined the names exactly as I have put above? In
which case, is this a problem in XL2000?

Thanks for all your help,
Rob