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.....