View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul paul is offline
external usenet poster
 
Posts: 247
Default Can the Row_Index_Num in HLOOKUP adjust relatively?

my formulas are broken down on monday mornings.By friday I can string a few
functions together<g
paul

remove nospam for email addy!



"Richard Buttrey" wrote:

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
__________________________