Posted to microsoft.public.excel.worksheet.functions

fedude

external usenet poster

Posts: 74

What relative row I'm in?

I have a large array (startingHoles). Next to te array I have a column
containing a formula This formula needs to know the relative row of the
array it's next to for use in the formula.

Here is the formula:

=HLOOKUP(weekNumber,startingHoles,5,FALSE)

The "5" in the formula above is the relative row it's next to. I'd rather
not have to edit every cell in this column to increment this number.

Looking for a better way.....

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Relative references	GARY	Excel Discussion (Misc queries)	7	June 16th 06 10:08 PM
Relative references	GARY	Excel Discussion (Misc queries)	1	June 16th 06 09:23 PM
Relative Queries	Paul Hammond	Excel Discussion (Misc queries)	1	January 5th 06 03:49 AM
Relative Addressing	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	February 20th 05 04:43 AM
Relative reference	Lakebum	Excel Worksheet Functions	2	December 28th 04 05:57 PM

All times are GMT +1. The time now is 03:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us