On Fri, 25 Aug 2006 05:14:02 -0700, paul
wrote:

or use match directly in the vlookup or hlookup to find the row or column
you want

Indeed.

Matter of personal preference I suppose. I tend to break formula down
in a case like this.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________