Thread
:
Can the Row_Index_Num in HLOOKUP adjust relatively?
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
paul
external usenet poster
Posts: 247
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
__________________________
Reply With Quote
paul
View Public Profile
Find all posts by paul